Overview

Dataset info

Number of variables181
Number of observations265
Missing cells21158 (44.1%)
Duplicate rows0 (0.0%)
Total size in memory361.4 KiB
Average record size in memory1.4 KiB

Variables types

Numeric62
Categorical20
Boolean10
Date0
URL0
Text (Unique)1
Rejected88
Unsupported0

Warnings

coligada_mais_antiga_ativa has 189 (71.3%) missing values Missing
coligada_mais_antiga_baixada has constant value "nan" Rejected
coligada_mais_nova_ativa has 189 (71.3%) missing values Missing
coligada_mais_nova_baixada has constant value "nan" Rejected
de_indicador_telefone has constant value "BOA" Rejected
dt_situacao only contains datetime values, but is categorical. Consider applying pd.to_datetime()Type
dt_situacao has a high cardinality: 129 distinct values Warning
empsetorcensitariofaixarendapopulacao has 48 (18.1%) missing values Missing
faturamento_est_coligados has 191 (72.1%) missing values Missing
faturamento_est_coligados_gp is highly correlated with faturamento_est_coligados (ρ = 0.97256) Rejected
fl_epp has constant value "False" Rejected
fl_matriz has constant value "True" Rejected
fl_me has constant value "False" Rejected
fl_mei has constant value "False" Rejected
fl_optante_simei has constant value "False" Rejected
fl_passivel_iss has constant value "True" Rejected
fl_st_especial has constant value "False" Rejected
grau_instrucao_macro_analfabeto has 201 (75.8%) missing values Missing
grau_instrucao_macro_desconhecido has constant value "nan" Rejected
grau_instrucao_macro_escolaridade_fundamental has 12 (4.5%) missing values Missing
grau_instrucao_macro_escolaridade_superior has 3 (1.1%) missing values Missing
idade_acima_de_58 has 8 (3.0%) missing values Missing
idade_ate_18 has 208 (78.5%) missing values Missing
idade_de_19_a_23 has 76 (28.7%) missing values Missing
idade_de_24_a_28 is highly correlated with idade_de_19_a_23 (ρ = 0.93912) Rejected
idade_de_39_a_43 is highly correlated with idade_de_34_a_38 (ρ = 0.91473) Rejected
idade_de_44_a_48 is highly correlated with idade_de_39_a_43 (ρ = 0.93769) Rejected
idade_de_54_a_58 is highly correlated with idade_acima_de_58 (ρ = 0.95005) Rejected
idade_maxima_coligadas is highly correlated with coligada_mais_antiga_ativa (ρ = 0.99076) Rejected
idade_maxima_socios has 172 (64.9%) missing values Missing
idade_media_coligadas has 189 (71.3%) missing values Missing
idade_media_coligadas_ativas is highly correlated with idade_media_coligadas (ρ = 0.99283) Rejected
idade_media_coligadas_baixadas has constant value "nan" Rejected
idade_media_socios has 172 (64.9%) missing values Missing
idade_minima_coligadas is highly correlated with coligada_mais_nova_ativa (ρ = 1) Rejected
idade_minima_socios is highly correlated with idade_media_socios (ρ = 0.90301) Rejected
max_faturamento_est_coligados is highly correlated with faturamento_est_coligados (ρ = 0.94847) Rejected
max_faturamento_est_coligados_gp is highly correlated with max_faturamento_est_coligados (ρ = 0.95153) Rejected
max_filiais_coligados has 229 (86.4%) missing values Missing
max_funcionarios_coligados_gp is highly correlated with max_filiais_coligados (ρ = 0.93125) Rejected
max_vl_folha_coligados has 207 (78.1%) missing values Missing
max_vl_folha_coligados_gp has 206 (77.7%) missing values Missing
media_faturamento_est_coligados is highly correlated with max_faturamento_est_coligados (ρ = 0.90753) Rejected
media_faturamento_est_coligados_gp is highly correlated with media_faturamento_est_coligados (ρ = 0.94656) Rejected
media_filiais_coligados has 229 (86.4%) missing values Missing
media_funcionarios_coligados_gp has 4 (1.5%) zeros Zeros
media_funcionarios_coligados_gp has 202 (76.2%) missing values Missing
media_vl_folha_coligados has 207 (78.1%) missing values Missing
media_vl_folha_coligados_gp has 206 (77.7%) missing values Missing
min_faturamento_est_coligados has 191 (72.1%) missing values Missing
min_faturamento_est_coligados_gp is highly correlated with min_faturamento_est_coligados (ρ = 0.98448) Rejected
min_filiais_coligados has 229 (86.4%) missing values Missing
min_funcionarios_coligados_gp is highly correlated with min_filiais_coligados (ρ = 0.91607) Rejected
min_meses_servicos is highly correlated with meses_ultima_contratacaco (ρ = 0.95675) Rejected
min_meses_servicos_all has 19 (7.2%) zeros Zeros
min_vl_folha_coligados is highly correlated with min_funcionarios_coligados_gp (ρ = 0.99898) Rejected
min_vl_folha_coligados_gp is highly correlated with min_vl_folha_coligados (ρ = 0.99917) Rejected
nm_meso_regiao has 24 (9.1%) missing values Missing
nm_micro_regiao has a high cardinality: 57 distinct values Warning
nm_micro_regiao has 24 (9.1%) missing values Missing
qt_admitidos_12meses has 162 (61.1%) zeros Zeros
qt_alteracao_socio_180d has constant value "nan" Rejected
qt_alteracao_socio_365d has constant value "nan" Rejected
qt_alteracao_socio_90d has constant value "nan" Rejected
qt_alteracao_socio_total has constant value "nan" Rejected
qt_art has 135 (50.9%) missing values Missing
qt_coligadas has 189 (71.3%) missing values Missing
qt_coligados is highly correlated with qt_coligadas (ρ = 1) Rejected
qt_coligados_agropecuaria has 189 (71.3%) missing values Missing
qt_coligados_atividade_alto has constant value "0.0" Rejected
qt_coligados_atividade_baixo has constant value "0.0" Rejected
qt_coligados_atividade_inativo has constant value "0.0" Rejected
qt_coligados_atividade_medio has constant value "0.0" Rejected
qt_coligados_atividade_mt_baixo has constant value "0.0" Rejected
qt_coligados_ativo is highly correlated with qt_coligados (ρ = 0.99975) Rejected
qt_coligados_baixada is highly correlated with max_funcionarios_coligados_gp (ρ = 0.97185) Rejected
qt_coligados_ccivil has 189 (71.3%) missing values Missing
qt_coligados_centro has 68 (25.7%) zeros Zeros
qt_coligados_centro has 189 (71.3%) missing values Missing
qt_coligados_comercio has 46 (17.4%) zeros Zeros
qt_coligados_comercio has 189 (71.3%) missing values Missing
qt_coligados_epp has constant value "0.0" Rejected
qt_coligados_exterior has constant value "0.0" Rejected
qt_coligados_inapta is highly correlated with max_funcionarios_coligados_gp (ρ = 0.97185) Rejected
qt_coligados_industria has 63 (23.8%) zeros Zeros
qt_coligados_industria has 189 (71.3%) missing values Missing
qt_coligados_ltda has 69 (26.0%) zeros Zeros
qt_coligados_ltda has 189 (71.3%) missing values Missing
qt_coligados_matriz is highly correlated with qt_coligados_ativo (ρ = 0.9997) Rejected
qt_coligados_me has constant value "0.0" Rejected
qt_coligados_mei has 189 (71.3%) missing values Missing
qt_coligados_nordeste has 31 (11.7%) zeros Zeros
qt_coligados_nordeste has 189 (71.3%) missing values Missing
qt_coligados_norte has 39 (14.7%) zeros Zeros
qt_coligados_norte has 189 (71.3%) missing values Missing
qt_coligados_nula has constant value "0.0" Rejected
qt_coligados_sa has 64 (24.2%) zeros Zeros
qt_coligados_sa has 189 (71.3%) missing values Missing
qt_coligados_serviço is highly correlated with qt_coligados_matriz (ρ = 0.92884) Rejected
qt_coligados_sudeste has 65 (24.5%) zeros Zeros
qt_coligados_sudeste has 189 (71.3%) missing values Missing
qt_coligados_sul is highly correlated with qt_coligados_baixada (ρ = 0.96129) Rejected
qt_coligados_suspensa has constant value "0.0" Rejected
qt_desligados is highly correlated with qt_admitidos (ρ = 0.90561) Rejected
qt_desligados_12meses has 159 (60.0%) zeros Zeros
qt_ex_funcionarios is highly correlated with qt_desligados (ρ = 1) Rejected
qt_filiais has 155 (58.5%) zeros Zeros
qt_funcionarios_12meses is highly correlated with qt_funcionarios (ρ = 0.99487) Rejected
qt_funcionarios_24meses is highly correlated with qt_funcionarios_12meses (ρ = 0.96889) Rejected
qt_funcionarios_coligados has 5 (1.9%) zeros Zeros
qt_funcionarios_coligados has 202 (76.2%) missing values Missing
qt_funcionarios_coligados_gp is highly correlated with qt_coligados_inapta (ρ = 0.92314) Rejected
qt_funcionarios_grupo is highly correlated with qt_funcionarios_24meses (ρ = 0.9503) Rejected
qt_ramos_coligados is highly correlated with qt_coligados_matriz (ρ = 0.93462) Rejected
qt_regioes_coligados has 189 (71.3%) missing values Missing
qt_socios is highly correlated with qt_coligados_mei (ρ = 0.98995) Rejected
qt_socios_coligados has 189 (71.3%) missing values Missing
qt_socios_feminino is highly correlated with qt_socios (ρ = 0.99365) Rejected
qt_socios_masculino is highly correlated with qt_socios_feminino (ρ = 0.99163) Rejected
qt_socios_pep is highly correlated with qt_socios_masculino (ρ = 0.99546) Rejected
qt_socios_pf is highly correlated with qt_socios_pep (ρ = 0.99609) Rejected
qt_socios_pj has 83 (31.3%) zeros Zeros
qt_socios_pj has 167 (63.0%) missing values Missing
qt_socios_pj_ativos is highly correlated with qt_socios_pj (ρ = 1) Rejected
qt_socios_pj_baixados has constant value "0.0" Rejected
qt_socios_pj_inaptos has constant value "0.0" Rejected
qt_socios_pj_nulos has constant value "0.0" Rejected
qt_socios_pj_suspensos has constant value "0.0" Rejected
qt_socios_st_regular is highly correlated with qt_socios_pf (ρ = 0.99836) Rejected
qt_socios_st_suspensa has constant value "nan" Rejected
qt_ufs_coligados is highly correlated with qt_regioes_coligados (ρ = 0.90264) Rejected
setor has constant value "SERVIÇO" Rejected
sum_faturamento_estimado_coligadas is highly correlated with media_faturamento_est_coligados_gp (ρ = 0.90166) Rejected
total is highly correlated with qt_funcionarios_grupo (ρ = 0.97431) Rejected
total_filiais_coligados is highly correlated with qt_funcionarios_coligados_gp (ρ = 0.93546) Rejected
tx_crescimento_12meses has 161 (60.8%) zeros Zeros
tx_crescimento_24meses is highly correlated with tx_crescimento_12meses (ρ = 0.99596) Rejected
tx_rotatividade has 160 (60.4%) zeros Zeros
vl_faturamento_estimado_grupo_aux is highly correlated with vl_faturamento_estimado_aux (ρ = 0.9811) Rejected
vl_folha_coligados is highly correlated with qt_funcionarios_coligados (ρ = 0.96112) Rejected
vl_folha_coligados_gp is highly correlated with vl_folha_coligados (ρ = 0.94289) Rejected
vl_frota is highly correlated with qt_socios_pep (ρ = 0.91388) Rejected
vl_idade_maxima_socios_pj has 250 (94.3%) missing values Missing
vl_idade_media_socios_pj has 250 (94.3%) missing values Missing
vl_idade_minima_socios_pj has 250 (94.3%) missing values Missing
vl_potenc_cons_oleo_gas has 243 (91.7%) missing values Missing
vl_total_tancagem has 255 (96.2%) missing values Missing
vl_total_tancagem_grupo is highly correlated with vl_idade_minima_socios_pj (ρ = 0.94442) Rejected
vl_total_veiculos_antt has constant value "nan" Rejected
vl_total_veiculos_antt_grupo has constant value "nan" Rejected
vl_total_veiculos_leves is highly correlated with qt_socios_pep (ρ = 0.93282) Rejected
vl_total_veiculos_leves_grupo is highly correlated with vl_total_veiculos_leves (ρ = 0.99727) Rejected
vl_total_veiculos_pesados is highly correlated with vl_potenc_cons_oleo_gas (ρ = 0.9929) Rejected
vl_total_veiculos_pesados_grupo is highly correlated with vl_total_veiculos_pesados (ρ = 0.99781) Rejected

Variables

coligada_mais_antiga_ativa
Numeric

Distinct count77
Unique (%)29.1%
Missing (%)71.3%
Missing (n)189
Infinite (%)0.0%
Infinite (n)0
Mean289.75
Minimum2.3
Maximum642.67
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2.3
5-th percentile24.475
Q1116.31
Median272.78
Q3414.34
95-th percentile634.22
Maximum642.67
Range640.37
Interquartile range298.03

Descriptive statistics

Standard deviation193.49
Coef of variation0.66779
Kurtosis-1.0216
Mean289.75
MAD162.51
Skewness0.31894
Sum22021
Variance37440
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
276.63 1 0.4%
 
25.567 1 0.4%
 
42.367 1 0.4%
 
273.17 1 0.4%
 
74.767 1 0.4%
 
5.8 1 0.4%
 
404.8 1 0.4%
 
178.37 1 0.4%
 
158.6 1 0.4%
 
108.47 1 0.4%
 
Other values (66) 66 24.9%
 
(Missing) 189 71.3%
 

Minimum 5 values

ValueCountFrequency (%) 
2.3 1 0.4%
 
5.8 1 0.4%
 
19.1 1 0.4%
 
21.2 1 0.4%
 
25.567 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
642.67 1 0.4%
 
635.47 1 0.4%
 
635.23 1 0.4%
 
634.27 1 0.4%
 
634.2 1 0.4%
 

coligada_mais_antiga_baixada
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

coligada_mais_nova_ativa
Numeric

Distinct count74
Unique (%)27.9%
Missing (%)71.3%
Missing (n)189
Infinite (%)0.0%
Infinite (n)0
Mean92.769
Minimum2.0333
Maximum498.97
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2.0333
5-th percentile3.65
Q116.658
Median39.417
Q3122.04
95-th percentile334.4
Maximum498.97
Range496.93
Interquartile range105.38

Descriptive statistics

Standard deviation110.79
Coef of variation1.1942
Kurtosis2.4526
Mean92.769
MAD84.736
Skewness1.6771
Sum7050.5
Variance12274
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
19.1 2 0.8%
 
21.2 2 0.8%
 
96.967 2 0.8%
 
161.37 1 0.4%
 
276.63 1 0.4%
 
16.533 1 0.4%
 
8.0333 1 0.4%
 
14.333 1 0.4%
 
26.3 1 0.4%
 
35.567 1 0.4%
 
Other values (63) 63 23.8%
 
(Missing) 189 71.3%
 

Minimum 5 values

ValueCountFrequency (%) 
2.0333 1 0.4%
 
2.3 1 0.4%
 
2.4 1 0.4%
 
3.2 1 0.4%
 
3.8 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
498.97 1 0.4%
 
408.47 1 0.4%
 
377.9 1 0.4%
 
355.8 1 0.4%
 
327.27 1 0.4%
 

coligada_mais_nova_baixada
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

de_faixa_faturamento_estimado
Categorical

Distinct count6
Unique (%)2.3%
Missing (%)0.0%
Missing (n)0
DE R$ 30.000.000,01 A R$ 100.000.000,00
138
DE R$ 10.000.000,01 A R$ 30.000.000,00
61
DE R$ 100.000.000,01 A R$ 300.000.000,00
49
Other values (3)
 
17
ValueCountFrequency (%) 
DE R$ 30.000.000,01 A R$ 100.000.000,00 138 52.1%
 
DE R$ 10.000.000,01 A R$ 30.000.000,00 61 23.0%
 
DE R$ 100.000.000,01 A R$ 300.000.000,00 49 18.5%
 
DE R$ 300.000.000,01 A R$ 500.000.000,00 9 3.4%
 
DE R$ 500.000.000,01 A 1 BILHAO DE REAIS 6 2.3%
 
ACIMA DE 1 BILHAO DE REAIS 2 0.8%
 
Max length40
Mean length38.913
Min length26
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

de_faixa_faturamento_estimado_grupo
Categorical

Distinct count6
Unique (%)2.3%
Missing (%)0.0%
Missing (n)0
DE R$ 30.000.000,01 A R$ 100.000.000,00
135
DE R$ 10.000.000,01 A R$ 30.000.000,00
59
DE R$ 100.000.000,01 A R$ 300.000.000,00
54
Other values (3)
 
17
ValueCountFrequency (%) 
DE R$ 30.000.000,01 A R$ 100.000.000,00 135 50.9%
 
DE R$ 10.000.000,01 A R$ 30.000.000,00 59 22.3%
 
DE R$ 100.000.000,01 A R$ 300.000.000,00 54 20.4%
 
DE R$ 500.000.000,01 A 1 BILHAO DE REAIS 7 2.6%
 
DE R$ 300.000.000,01 A R$ 500.000.000,00 7 2.6%
 
ACIMA DE 1 BILHAO DE REAIS 3 1.1%
 
Max length40
Mean length38.887
Min length26
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

de_indicador_telefone
Constant

This variable is constant and should be ignored for analysis

Constant valueBOA

de_natureza_juridica
Categorical

Distinct count25
Unique (%)9.4%
Missing (%)0.0%
Missing (n)0
MUNICIPIO
108
SOCIEDADE EMPRESARIA LIMITADA
62
ORGAO PUBLICO DO PODER EXECUTIVO ESTADUAL OU DO DISTRITO FEDERAL
 
20
Other values (22)
75
ValueCountFrequency (%) 
MUNICIPIO 108 40.8%
 
SOCIEDADE EMPRESARIA LIMITADA 62 23.4%
 
ORGAO PUBLICO DO PODER EXECUTIVO ESTADUAL OU DO DISTRITO FEDERAL 20 7.5%
 
EMPRESA INDIVIDUAL DE RESPONSABILIDADE LIMITADA DE NATUREZA EMPRESARIA 13 4.9%
 
ORGAO PUBLICO DO PODER EXECUTIVO MUNICIPAL 9 3.4%
 
ASSOCIACAO PRIVADA 8 3.0%
 
AUTARQUIA ESTADUAL OU DO DISTRITO FEDERAL 6 2.3%
 
SERVICO SOCIAL AUTONOMO 5 1.9%
 
AUTARQUIA FEDERAL 4 1.5%
 
COOPERATIVA 4 1.5%
 
Other values (15) 26 9.8%
 
Max length70
Mean length25.585
Min length9
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

de_nivel_atividade
Categorical

Distinct count3
Unique (%)1.1%
Missing (%)0.0%
Missing (n)0
ALTA
236
MEDIA
 
26
BAIXA
 
3
ValueCountFrequency (%) 
ALTA 236 89.1%
 
MEDIA 26 9.8%
 
BAIXA 3 1.1%
 
Max length5
Mean length4.1094
Min length4
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

de_ramo
Categorical

Distinct count16
Unique (%)6.0%
Missing (%)0.0%
Missing (n)0
ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL
150
SERVICOS ADMINISTRATIVOS
35
SERVICOS DE EDUCACAO
 
22
Other values (13)
58
ValueCountFrequency (%) 
ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL 150 56.6%
 
SERVICOS ADMINISTRATIVOS 35 13.2%
 
SERVICOS DE EDUCACAO 22 8.3%
 
TRANSPORTE, ARMAZENAGEM E CORREIO 14 5.3%
 
SERVICOS DE SAUDE 13 4.9%
 
SERVICOS DE ALOJAMENTO/ALIMENTACAO 5 1.9%
 
SERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOS 5 1.9%
 
SERVICOS DE SANEAMENTO BASICO 5 1.9%
 
SERVICOS DIVERSOS 4 1.5%
 
SEGUROS, PLANOS DE PREVIDENCIA E PLANOS DE SAUDE 3 1.1%
 
Other values (6) 9 3.4%
 
Max length49
Mean length38.547
Min length7
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

de_saude_rescencia
Categorical

Distinct count3
Unique (%)1.1%
Missing (%)0.0%
Missing (n)0
ACIMA DE 1 ANO
263
SEM INFORMACAO
 
1
ATE 1 ANO
 
1
ValueCountFrequency (%) 
ACIMA DE 1 ANO 263 99.2%
 
SEM INFORMACAO 1 0.4%
 
ATE 1 ANO 1 0.4%
 
Max length14
Mean length13.981
Min length9
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

de_saude_tributaria
Categorical

Distinct count5
Unique (%)1.9%
Missing (%)0.0%
Missing (n)0
VERDE
159
AZUL
83
LARANJA
 
20
Other values (2)
 
3
ValueCountFrequency (%) 
VERDE 159 60.0%
 
AZUL 83 31.3%
 
LARANJA 20 7.5%
 
VERMELHO 2 0.8%
 
CINZA 1 0.4%
 
Max length8
Mean length4.8604
Min length4
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

dt_situacao
Categorical

Distinct count129
Unique (%)48.7%
Missing (%)0.0%
Missing (n)0
2005-11-03
85
1998-07-28
 
13
2005-09-24
 
10
Other values (126)
157
ValueCountFrequency (%) 
2005-11-03 85 32.1%
 
1998-07-28 13 4.9%
 
2005-09-24 10 3.8%
 
2005-10-14 4 1.5%
 
2005-08-27 4 1.5%
 
2005-10-28 4 1.5%
 
1999-02-27 4 1.5%
 
2005-10-22 3 1.1%
 
2005-08-06 3 1.1%
 
2005-10-07 3 1.1%
 
Other values (119) 132 49.8%
 
Max length10
Mean length10
Min length10
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

empsetorcensitariofaixarendapopulacao
Numeric

Distinct count208
Unique (%)78.5%
Missing (%)18.1%
Missing (n)48
Infinite (%)0.0%
Infinite (n)0
Mean1587.1
Minimum297.41
Maximum6347.9
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum297.41
5-th percentile405.49
Q1708.95
Median1072.3
Q32179.9
95-th percentile4133.9
Maximum6347.9
Range6050.4
Interquartile range1471

Descriptive statistics

Standard deviation1235.8
Coef of variation0.77862
Kurtosis2.3859
Mean1587.1
MAD949.7
Skewness1.5881
Sum3.444e+05
Variance1.5271e+06
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1005.1 3 1.1%
 
1068.1 2 0.8%
 
2317.1 2 0.8%
 
1881.3 2 0.8%
 
2179.9 2 0.8%
 
1213.5 2 0.8%
 
1375.7 2 0.8%
 
2799.8 2 0.8%
 
1530.2 2 0.8%
 
960.76 1 0.4%
 
Other values (197) 197 74.3%
 
(Missing) 48 18.1%
 

Minimum 5 values

ValueCountFrequency (%) 
297.41 1 0.4%
 
339.08 1 0.4%
 
353.66 1 0.4%
 
365.15 1 0.4%
 
365.3 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
6347.9 1 0.4%
 
5985.5 1 0.4%
 
5985.4 1 0.4%
 
5463.1 1 0.4%
 
5261.2 1 0.4%
 

faturamento_est_coligados
Numeric

Distinct count62
Unique (%)23.4%
Missing (%)72.1%
Missing (n)191
Infinite (%)0.0%
Infinite (n)0
Mean2.8928e+08
Minimum1.2364e+05
Maximum7.5599e+09
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1.2364e+05
5-th percentile2.1e+05
Q18.0728e+05
Median5.1921e+06
Q35.5464e+07
95-th percentile7.1005e+08
Maximum7.5599e+09
Range7.5598e+09
Interquartile range5.4657e+07

Descriptive statistics

Standard deviation1.1358e+09
Coef of variation3.9263
Kurtosis28.391
Mean2.8928e+08
MAD4.5845e+08
Skewness5.228
Sum2.1407e+10
Variance1.2901e+18
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2.1e+05 10 3.8%
 
4.2e+05 3 1.1%
 
9.3e+05 2 0.8%
 
4.9455e+05 2 0.8%
 
5.223e+09 1 0.4%
 
8.4164e+07 1 0.4%
 
3.7272e+09 1 0.4%
 
1.1282e+07 1 0.4%
 
9.2894e+08 1 0.4%
 
3.4491e+06 1 0.4%
 
Other values (51) 51 19.2%
 
(Missing) 191 72.1%
 

Minimum 5 values

ValueCountFrequency (%) 
1.2364e+05 1 0.4%
 
2.1e+05 10 3.8%
 
2.4728e+05 1 0.4%
 
2.8849e+05 1 0.4%
 
4.2e+05 3 1.1%
 

Maximum 5 values

ValueCountFrequency (%) 
7.5599e+09 1 0.4%
 
5.223e+09 1 0.4%
 
3.7272e+09 1 0.4%
 
9.2894e+08 1 0.4%
 
5.9219e+08 1 0.4%
 

faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with faturamento_est_coligados and should be ignored for analysis

Correlation0.97256

fl_antt
Boolean

Distinct count2
Unique (%)0.8%
Missing (%)0.0%
Missing (n)0
False
253
True
 
12
ValueCountFrequency (%) 
False 253 95.5%
 
True 12 4.5%
 

fl_email
Boolean

Distinct count2
Unique (%)0.8%
Missing (%)0.0%
Missing (n)0
False
147
True
118
ValueCountFrequency (%) 
False 147 55.5%
 
True 118 44.5%
 

fl_epp
Constant

This variable is constant and should be ignored for analysis

Constant valueFalse

fl_ltda
Boolean

Distinct count2
Unique (%)0.8%
Missing (%)0.0%
Missing (n)0
False
264
True
 
1
ValueCountFrequency (%) 
False 264 99.6%
 
True 1 0.4%
 

fl_matriz
Constant

This variable is constant and should be ignored for analysis

Constant valueTrue

fl_me
Constant

This variable is constant and should be ignored for analysis

Constant valueFalse

fl_mei
Constant

This variable is constant and should be ignored for analysis

Constant valueFalse

fl_optante_simei
Constant

This variable is constant and should be ignored for analysis

Constant valueFalse

fl_optante_simples
Boolean

Distinct count3
Unique (%)1.1%
Missing (%)0.8%
Missing (n)2
False
252
True
 
11
(Missing)
 
2
ValueCountFrequency (%) 
False 252 95.1%
 
True 11 4.2%
 
(Missing) 2 0.8%
 

fl_passivel_iss
Constant

This variable is constant and should be ignored for analysis

Constant valueTrue

fl_rm
Categorical

Distinct count2
Unique (%)0.8%
Missing (%)0.0%
Missing (n)0
NAO
145
SIM
120
ValueCountFrequency (%) 
NAO 145 54.7%
 
SIM 120 45.3%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

fl_sa
Boolean

Distinct count2
Unique (%)0.8%
Missing (%)0.0%
Missing (n)0
False
260
True
 
5
ValueCountFrequency (%) 
False 260 98.1%
 
True 5 1.9%
 

fl_simples_irregular
Boolean

Distinct count2
Unique (%)0.8%
Missing (%)0.0%
Missing (n)0
False
264
True
 
1
ValueCountFrequency (%) 
False 264 99.6%
 
True 1 0.4%
 

fl_spa
Boolean

Distinct count2
Unique (%)0.8%
Missing (%)0.0%
Missing (n)0
False
255
True
 
10
ValueCountFrequency (%) 
False 255 96.2%
 
True 10 3.8%
 

fl_st_especial
Constant

This variable is constant and should be ignored for analysis

Constant valueFalse

fl_telefone
Boolean

Distinct count2
Unique (%)0.8%
Missing (%)0.0%
Missing (n)0
False
133
True
132
ValueCountFrequency (%) 
False 133 50.2%
 
True 132 49.8%
 

fl_veiculo
Boolean

Distinct count2
Unique (%)0.8%
Missing (%)0.0%
Missing (n)0
True
221
False
 
44
ValueCountFrequency (%) 
True 221 83.4%
 
False 44 16.6%
 

grau_instrucao_macro_analfabeto
Numeric

Distinct count15
Unique (%)5.7%
Missing (%)75.8%
Missing (n)201
Infinite (%)0.0%
Infinite (n)0
Mean6.2188
Minimum1
Maximum66
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median2
Q34.25
95-th percentile24
Maximum66
Range65
Interquartile range3.25

Descriptive statistics

Standard deviation12.356
Coef of variation1.987
Kurtosis15.394
Mean6.2188
MAD6.6924
Skewness3.8057
Sum398
Variance152.68
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 24 9.1%
 
2 13 4.9%
 
3 8 3.0%
 
24 3 1.1%
 
4 3 1.1%
 
9 2 0.8%
 
8 2 0.8%
 
6 2 0.8%
 
7 2 0.8%
 
64 1 0.4%
 
Other values (4) 4 1.5%
 
(Missing) 201 75.8%
 

Minimum 5 values

ValueCountFrequency (%) 
1 24 9.1%
 
2 13 4.9%
 
3 8 3.0%
 
4 3 1.1%
 
5 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
66 1 0.4%
 
64 1 0.4%
 
33 1 0.4%
 
24 3 1.1%
 
12 1 0.4%
 

grau_instrucao_macro_desconhecido
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

grau_instrucao_macro_escolaridade_fundamental
Numeric

Distinct count130
Unique (%)49.1%
Missing (%)4.5%
Missing (n)12
Infinite (%)0.0%
Infinite (n)0
Mean76.553
Minimum1
Maximum668
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1.6
Q115
Median45
Q396
95-th percentile253
Maximum668
Range667
Interquartile range81

Descriptive statistics

Standard deviation105.81
Coef of variation1.3822
Kurtosis11.184
Mean76.553
MAD66.396
Skewness3.0869
Sum19368
Variance11196
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 13 4.9%
 
18 7 2.6%
 
19 6 2.3%
 
4 6 2.3%
 
7 6 2.3%
 
9 5 1.9%
 
17 5 1.9%
 
15 5 1.9%
 
54 5 1.9%
 
12 5 1.9%
 
Other values (119) 190 71.7%
 
(Missing) 12 4.5%
 

Minimum 5 values

ValueCountFrequency (%) 
1 13 4.9%
 
2 4 1.5%
 
3 4 1.5%
 
4 6 2.3%
 
5 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
668 1 0.4%
 
595 1 0.4%
 
576 1 0.4%
 
559 1 0.4%
 
499 1 0.4%
 

grau_instrucao_macro_escolaridade_media
Numeric

Distinct count196
Unique (%)74.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean221.03
Minimum4
Maximum2447
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum4
5-th percentile23
Q173
Median140
Q3255
95-th percentile638.6
Maximum2447
Range2443
Interquartile range182

Descriptive statistics

Standard deviation273.2
Coef of variation1.2361
Kurtosis22.399
Mean221.03
MAD162.84
Skewness3.9717
Sum58572
Variance74639
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 4. 150.5 255.5 400.5 722.5 2447. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
134 4 1.5%
 
145 4 1.5%
 
49 4 1.5%
 
35 3 1.1%
 
122 3 1.1%
 
23 3 1.1%
 
117 3 1.1%
 
252 3 1.1%
 
40 3 1.1%
 
107 3 1.1%
 
Other values (186) 232 87.5%
 

Minimum 5 values

ValueCountFrequency (%) 
4 1 0.4%
 
5 1 0.4%
 
6 2 0.8%
 
9 1 0.4%
 
11 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
2447 1 0.4%
 
1662 1 0.4%
 
1581 1 0.4%
 
1193 2 0.8%
 
1164 1 0.4%
 

grau_instrucao_macro_escolaridade_superior
Numeric

Distinct count179
Unique (%)67.5%
Missing (%)1.1%
Missing (n)3
Infinite (%)0.0%
Infinite (n)0
Mean174.04
Minimum1
Maximum2471
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile3
Q140.25
Median90
Q3192.75
95-th percentile567.75
Maximum2471
Range2470
Interquartile range152.5

Descriptive statistics

Standard deviation272.83
Coef of variation1.5676
Kurtosis26.496
Mean174.04
MAD155.01
Skewness4.4077
Sum45599
Variance74437
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
3 7 2.6%
 
2 5 1.9%
 
56 4 1.5%
 
8 4 1.5%
 
7 4 1.5%
 
72 4 1.5%
 
63 4 1.5%
 
44 3 1.1%
 
13 3 1.1%
 
37 3 1.1%
 
Other values (168) 221 83.4%
 

Minimum 5 values

ValueCountFrequency (%) 
1 3 1.1%
 
2 5 1.9%
 
3 7 2.6%
 
4 2 0.8%
 
5 2 0.8%
 

Maximum 5 values

ValueCountFrequency (%) 
2471 1 0.4%
 
1820 1 0.4%
 
1349 1 0.4%
 
1292 1 0.4%
 
1168 1 0.4%
 

id
Categorical, Unique

First 5 values
001f6dfaefdbbe31deedb00996c8a87dd90342690611d6a0be7fbb19e4b5326c
01a586fca9efeab9f83ccab019962b0887882fac2625fe8363da97276c25e0f2
03db1b36296ff895e6494a04d94795b247a78301dec8c0559bed9924436cc058
04732bec03125a8a17f1191cbd7c6dc675628bbb87125c4f717b81d9c3bedd6e
04d34dcdee40a44560907165ab68f8e0ec771c0b94321f688d7a202d73f52673
Last 5 values
fe796f2c60812f6fe96affa216079cf548daa25c3b72ea746d8ad2c25c131d1b
fea23f072675ec89f9b6ffd040777f5ff562c9d76239180a2e1786f917f3a52f
feb9c97a3f694c22a919d9544c433da92d34d5717b43d54d88f543aa462958ae
ff6f9b8c9ff446342c06e6a858e9589e708412ffd409b3ff71d663ecf8761bc6
ff9ff2ac35ec7cf5c7d5ed561010a53a953108110a3f5cdcea92945d94b62d38

First 5 values

ValueCountFrequency (%) 
001f6dfaefdbbe31deedb00996c8a87dd90342690611d6a0be7fbb19e4b5326c 1 0.4%
 
01a586fca9efeab9f83ccab019962b0887882fac2625fe8363da97276c25e0f2 1 0.4%
 
03db1b36296ff895e6494a04d94795b247a78301dec8c0559bed9924436cc058 1 0.4%
 
04732bec03125a8a17f1191cbd7c6dc675628bbb87125c4f717b81d9c3bedd6e 1 0.4%
 
04d34dcdee40a44560907165ab68f8e0ec771c0b94321f688d7a202d73f52673 1 0.4%
 

Last 5 values

ValueCountFrequency (%) 
ff9ff2ac35ec7cf5c7d5ed561010a53a953108110a3f5cdcea92945d94b62d38 1 0.4%
 
ff6f9b8c9ff446342c06e6a858e9589e708412ffd409b3ff71d663ecf8761bc6 1 0.4%
 
feb9c97a3f694c22a919d9544c433da92d34d5717b43d54d88f543aa462958ae 1 0.4%
 
fea23f072675ec89f9b6ffd040777f5ff562c9d76239180a2e1786f917f3a52f 1 0.4%
 
fe796f2c60812f6fe96affa216079cf548daa25c3b72ea746d8ad2c25c131d1b 1 0.4%
 

idade_acima_de_58
Numeric

Distinct count105
Unique (%)39.6%
Missing (%)3.0%
Missing (n)8
Infinite (%)0.0%
Infinite (n)0
Mean53.911
Minimum1
Maximum1844
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile2
Q110
Median27
Q357
95-th percentile182.2
Maximum1844
Range1843
Interquartile range47

Descriptive statistics

Standard deviation131.14
Coef of variation2.4326
Kurtosis138.73
Mean53.911
MAD50.679
Skewness10.651
Sum13855
Variance17199
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2 9 3.4%
 
5 9 3.4%
 
17 8 3.0%
 
3 8 3.0%
 
6 8 3.0%
 
11 8 3.0%
 
12 8 3.0%
 
1 7 2.6%
 
4 6 2.3%
 
8 6 2.3%
 
Other values (94) 180 67.9%
 
(Missing) 8 3.0%
 

Minimum 5 values

ValueCountFrequency (%) 
1 7 2.6%
 
2 9 3.4%
 
3 8 3.0%
 
4 6 2.3%
 
5 9 3.4%
 

Maximum 5 values

ValueCountFrequency (%) 
1844 1 0.4%
 
727 1 0.4%
 
307 1 0.4%
 
254 1 0.4%
 
235 1 0.4%
 

idade_ate_18
Numeric

Distinct count13
Unique (%)4.9%
Missing (%)78.5%
Missing (n)208
Infinite (%)0.0%
Infinite (n)0
Mean4.4035
Minimum1
Maximum56
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median2
Q35
95-th percentile10
Maximum56
Range55
Interquartile range4

Descriptive statistics

Standard deviation7.5967
Coef of variation1.7251
Kurtosis39.315
Mean4.4035
MAD3.5279
Skewness5.8714
Sum251
Variance57.709
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 16 6.0%
 
2 13 4.9%
 
3 10 3.8%
 
6 5 1.9%
 
7 3 1.1%
 
4 2 0.8%
 
10 2 0.8%
 
5 2 0.8%
 
8 1 0.4%
 
56 1 0.4%
 
Other values (2) 2 0.8%
 
(Missing) 208 78.5%
 

Minimum 5 values

ValueCountFrequency (%) 
1 16 6.0%
 
2 13 4.9%
 
3 10 3.8%
 
4 2 0.8%
 
5 2 0.8%
 

Maximum 5 values

ValueCountFrequency (%) 
56 1 0.4%
 
17 1 0.4%
 
10 2 0.8%
 
9 1 0.4%
 
8 1 0.4%
 

idade_de_19_a_23
Numeric

Distinct count43
Unique (%)16.2%
Missing (%)28.7%
Missing (n)76
Infinite (%)0.0%
Infinite (n)0
Mean15.143
Minimum1
Maximum643
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q13
Median6
Q316
95-th percentile37.8
Maximum643
Range642
Interquartile range13

Descriptive statistics

Standard deviation48.702
Coef of variation3.2162
Kurtosis148.95
Mean15.143
MAD14.887
Skewness11.647
Sum2862
Variance2371.9
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 27 10.2%
 
2 19 7.2%
 
3 15 5.7%
 
4 13 4.9%
 
6 12 4.5%
 
5 12 4.5%
 
7 10 3.8%
 
10 8 3.0%
 
18 6 2.3%
 
19 5 1.9%
 
Other values (32) 62 23.4%
 
(Missing) 76 28.7%
 

Minimum 5 values

ValueCountFrequency (%) 
1 27 10.2%
 
2 19 7.2%
 
3 15 5.7%
 
4 13 4.9%
 
5 12 4.5%
 

Maximum 5 values

ValueCountFrequency (%) 
643 1 0.4%
 
139 1 0.4%
 
102 1 0.4%
 
65 1 0.4%
 
57 1 0.4%
 

idade_de_24_a_28
Highly correlated

This variable is highly correlated with idade_de_19_a_23 and should be ignored for analysis

Correlation0.93912

idade_de_29_a_33
Numeric

Distinct count117
Unique (%)44.2%
Missing (%)0.4%
Missing (n)1
Infinite (%)0.0%
Infinite (n)0
Mean61.936
Minimum2
Maximum749
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2
5-th percentile8
Q123.75
Median40
Q370.25
95-th percentile171.95
Maximum749
Range747
Interquartile range46.5

Descriptive statistics

Standard deviation81.473
Coef of variation1.3154
Kurtosis29.987
Mean61.936
MAD44.977
Skewness4.7249
Sum16351
Variance6637.8
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
32 7 2.6%
 
31 7 2.6%
 
11 7 2.6%
 
40 6 2.3%
 
22 6 2.3%
 
10 6 2.3%
 
27 6 2.3%
 
29 5 1.9%
 
25 5 1.9%
 
45 5 1.9%
 
Other values (106) 204 77.0%
 

Minimum 5 values

ValueCountFrequency (%) 
2 2 0.8%
 
3 1 0.4%
 
4 1 0.4%
 
5 1 0.4%
 
6 2 0.8%
 

Maximum 5 values

ValueCountFrequency (%) 
749 1 0.4%
 
603 1 0.4%
 
517 1 0.4%
 
357 1 0.4%
 
325 1 0.4%
 

idade_de_34_a_38
Numeric

Distinct count123
Unique (%)46.4%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean77.075
Minimum1
Maximum682
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile12
Q128
Median45
Q3102
95-th percentile246
Maximum682
Range681
Interquartile range74

Descriptive statistics

Standard deviation85.411
Coef of variation1.1081
Kurtosis14.194
Mean77.075
MAD55.996
Skewness3.181
Sum20425
Variance7295
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 1. 18.5 48.5 130. 189.5 371.5 682. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
28 8 3.0%
 
21 7 2.6%
 
27 6 2.3%
 
41 6 2.3%
 
33 6 2.3%
 
42 6 2.3%
 
34 6 2.3%
 
37 5 1.9%
 
22 5 1.9%
 
23 5 1.9%
 
Other values (113) 205 77.4%
 

Minimum 5 values

ValueCountFrequency (%) 
1 1 0.4%
 
3 2 0.8%
 
6 1 0.4%
 
9 2 0.8%
 
10 3 1.1%
 

Maximum 5 values

ValueCountFrequency (%) 
682 1 0.4%
 
535 1 0.4%
 
444 1 0.4%
 
375 1 0.4%
 
368 1 0.4%
 

idade_de_39_a_43
Highly correlated

This variable is highly correlated with idade_de_34_a_38 and should be ignored for analysis

Correlation0.91473

idade_de_44_a_48
Highly correlated

This variable is highly correlated with idade_de_39_a_43 and should be ignored for analysis

Correlation0.93769

idade_de_49_a_53
Numeric

Distinct count116
Unique (%)43.8%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean53.502
Minimum1
Maximum532
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile5.2
Q119
Median37
Q364
95-th percentile163
Maximum532
Range531
Interquartile range45

Descriptive statistics

Standard deviation58.867
Coef of variation1.1003
Kurtosis18.511
Mean53.502
MAD37.916
Skewness3.3741
Sum14178
Variance3465.3
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 1. 60.5 123.5 257. 532. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
14 9 3.4%
 
21 6 2.3%
 
22 6 2.3%
 
31 6 2.3%
 
15 6 2.3%
 
30 6 2.3%
 
28 6 2.3%
 
7 6 2.3%
 
16 5 1.9%
 
8 5 1.9%
 
Other values (106) 204 77.0%
 

Minimum 5 values

ValueCountFrequency (%) 
1 2 0.8%
 
2 2 0.8%
 
3 2 0.8%
 
4 4 1.5%
 
5 4 1.5%
 

Maximum 5 values

ValueCountFrequency (%) 
532 1 0.4%
 
315 1 0.4%
 
266 1 0.4%
 
248 1 0.4%
 
235 1 0.4%
 

idade_de_54_a_58
Highly correlated

This variable is highly correlated with idade_acima_de_58 and should be ignored for analysis

Correlation0.95005

idade_emp_cat
Categorical

Distinct count6
Unique (%)2.3%
Missing (%)0.0%
Missing (n)0
> 20
176
15 a 20
 
33
5 a 10
 
27
Other values (3)
 
29
ValueCountFrequency (%) 
> 20 176 66.4%
 
15 a 20 33 12.5%
 
5 a 10 27 10.2%
 
10 a 15 21 7.9%
 
1 a 5 7 2.6%
 
<= 1 1 0.4%
 
Max length7
Mean length4.8415
Min length4
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

idade_empresa_anos
Numeric

Distinct count214
Unique (%)80.8%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean27.763
Minimum0.76164
Maximum51.808
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum0.76164
5-th percentile6.0685
Q117.638
Median24.074
Q343.8
95-th percentile47.158
Maximum51.808
Range51.047
Interquartile range26.162

Descriptive statistics

Standard deviation14.12
Coef of variation0.50859
Kurtosis-1.3337
Mean27.763
MAD12.567
Skewness0.020109
Sum7357.1
Variance199.36
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0.76164384 7.58767123 21.78630137 21.88356164 43.43835616 ... 43.85342466 43.85616438 43.87123288 43.94794521 51.80821918], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
43.855 11 4.2%
 
21.836 9 3.4%
 
21.833 6 2.3%
 
43.866 6 2.3%
 
43.877 5 1.9%
 
43.847 4 1.5%
 
43.868 4 1.5%
 
43.8 3 1.1%
 
21.816 3 1.1%
 
21.814 3 1.1%
 
Other values (204) 211 79.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0.76164 1 0.4%
 
1.0027 1 0.4%
 
2.4986 1 0.4%
 
2.6 1 0.4%
 
2.9589 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
51.808 1 0.4%
 
51.499 1 0.4%
 
51.334 1 0.4%
 
50.929 1 0.4%
 
50.66 1 0.4%
 

idade_maxima_coligadas
Highly correlated

This variable is highly correlated with coligada_mais_antiga_ativa and should be ignored for analysis

Correlation0.99076

idade_maxima_socios
Numeric

Distinct count50
Unique (%)18.9%
Missing (%)64.9%
Missing (n)172
Infinite (%)0.0%
Infinite (n)0
Mean54.968
Minimum4
Maximum90
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum4
5-th percentile31.6
Q145
Median54
Q366
95-th percentile79.4
Maximum90
Range86
Interquartile range21

Descriptive statistics

Standard deviation15.466
Coef of variation0.28137
Kurtosis0.2466
Mean54.968
MAD12.354
Skewness-0.22492
Sum5112
Variance239.21
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
54 5 1.9%
 
50 4 1.5%
 
66 4 1.5%
 
49 4 1.5%
 
51 3 1.1%
 
33 3 1.1%
 
65 3 1.1%
 
47 3 1.1%
 
72 3 1.1%
 
55 3 1.1%
 
Other values (39) 58 21.9%
 
(Missing) 172 64.9%
 

Minimum 5 values

ValueCountFrequency (%) 
4 1 0.4%
 
27 1 0.4%
 
29 1 0.4%
 
30 1 0.4%
 
31 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
90 1 0.4%
 
86 1 0.4%
 
84 1 0.4%
 
82 1 0.4%
 
80 1 0.4%
 

idade_media_coligadas
Numeric

Distinct count77
Unique (%)29.1%
Missing (%)71.3%
Missing (n)189
Infinite (%)0.0%
Infinite (n)0
Mean174.05
Minimum2.3
Maximum498.97
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2.3
5-th percentile24.475
Q1102.83
Median156.66
Q3243.95
95-th percentile382.36
Maximum498.97
Range496.67
Interquartile range141.12

Descriptive statistics

Standard deviation108.48
Coef of variation0.62325
Kurtosis0.78332
Mean174.05
MAD85.839
Skewness0.8318
Sum13228
Variance11768
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
102.87 1 0.4%
 
358.94 1 0.4%
 
495.95 1 0.4%
 
16.8 1 0.4%
 
44.067 1 0.4%
 
276.63 1 0.4%
 
21.2 1 0.4%
 
194.23 1 0.4%
 
408.47 1 0.4%
 
102.72 1 0.4%
 
Other values (66) 66 24.9%
 
(Missing) 189 71.3%
 

Minimum 5 values

ValueCountFrequency (%) 
2.3 1 0.4%
 
5.8 1 0.4%
 
16.8 1 0.4%
 
21.2 1 0.4%
 
25.567 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
498.97 1 0.4%
 
495.95 1 0.4%
 
408.47 1 0.4%
 
389.98 1 0.4%
 
379.82 1 0.4%
 

idade_media_coligadas_ativas
Highly correlated

This variable is highly correlated with idade_media_coligadas and should be ignored for analysis

Correlation0.99283

idade_media_coligadas_baixadas
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

idade_media_socios
Numeric

Distinct count63
Unique (%)23.8%
Missing (%)64.9%
Missing (n)172
Infinite (%)0.0%
Infinite (n)0
Mean49.949
Minimum4
Maximum90
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum4
5-th percentile29.4
Q141
Median50
Q361
95-th percentile70.3
Maximum90
Range86
Interquartile range20

Descriptive statistics

Standard deviation13.803
Coef of variation0.27634
Kurtosis0.51101
Mean49.949
MAD11.173
Skewness-0.11851
Sum4645.3
Variance190.52
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
64 3 1.1%
 
63 3 1.1%
 
55 3 1.1%
 
47 3 1.1%
 
33 3 1.1%
 
50 3 1.1%
 
52 3 1.1%
 
69 2 0.8%
 
46.667 2 0.8%
 
64.5 2 0.8%
 
Other values (52) 66 24.9%
 
(Missing) 172 64.9%
 

Minimum 5 values

ValueCountFrequency (%) 
4 1 0.4%
 
27 2 0.8%
 
28 1 0.4%
 
28.5 1 0.4%
 
30 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
90 1 0.4%
 
75.667 1 0.4%
 
72 1 0.4%
 
71 1 0.4%
 
70.75 1 0.4%
 

idade_minima_coligadas
Highly correlated

This variable is highly correlated with coligada_mais_nova_ativa and should be ignored for analysis

Correlation1

idade_minima_socios
Highly correlated

This variable is highly correlated with idade_media_socios and should be ignored for analysis

Correlation0.90301

max_faturamento_est_coligados
Highly correlated

This variable is highly correlated with faturamento_est_coligados and should be ignored for analysis

Correlation0.94847

max_faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with max_faturamento_est_coligados and should be ignored for analysis

Correlation0.95153

max_filiais_coligados
Numeric

Distinct count15
Unique (%)5.7%
Missing (%)86.4%
Missing (n)229
Infinite (%)0.0%
Infinite (n)0
Mean40.583
Minimum1
Maximum666
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11.75
Median4
Q37
95-th percentile178.25
Maximum666
Range665
Interquartile range5.25

Descriptive statistics

Standard deviation120.67
Coef of variation2.9734
Kurtosis21.728
Mean40.583
MAD61.583
Skewness4.445
Sum1461
Variance14561
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 9 3.4%
 
4 4 1.5%
 
3 4 1.5%
 
2 4 1.5%
 
7 3 1.1%
 
6 3 1.1%
 
5 2 0.8%
 
275 1 0.4%
 
666 1 0.4%
 
146 1 0.4%
 
Other values (4) 4 1.5%
 
(Missing) 229 86.4%
 

Minimum 5 values

ValueCountFrequency (%) 
1 9 3.4%
 
2 4 1.5%
 
3 4 1.5%
 
4 4 1.5%
 
5 2 0.8%
 

Maximum 5 values

ValueCountFrequency (%) 
666 1 0.4%
 
275 1 0.4%
 
146 1 0.4%
 
140 1 0.4%
 
76 1 0.4%
 

max_funcionarios_coligados_gp
Highly correlated

This variable is highly correlated with max_filiais_coligados and should be ignored for analysis

Correlation0.93125

max_meses_servicos
Numeric

Distinct count228
Unique (%)86.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean472.16
Minimum6
Maximum5099.1
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum6
5-th percentile46.493
Q1251.5
Median414.33
Q3521.37
95-th percentile641.31
Maximum5099.1
Range5093.1
Interquartile range269.87

Descriptive statistics

Standard deviation729.18
Coef of variation1.5443
Kurtosis34.677
Mean472.16
MAD268.11
Skewness5.8153
Sum1.2512e+05
Variance5.317e+05
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 6. 251.51666667 268.21666667 481.31666667 506.15 508.08333333 596.41666667 693.5 5099.06666667], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
5099.1 6 2.3%
 
265.63 5 1.9%
 
470.67 5 1.9%
 
507.2 5 1.9%
 
265.67 4 1.5%
 
521.37 4 1.5%
 
481.83 3 1.1%
 
495.03 3 1.1%
 
263.7 2 0.8%
 
123.63 2 0.8%
 
Other values (218) 226 85.3%
 

Minimum 5 values

ValueCountFrequency (%) 
6 1 0.4%
 
13.067 1 0.4%
 
26.233 1 0.4%
 
29.3 1 0.4%
 
30.333 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
5099.1 6 2.3%
 
804.43 1 0.4%
 
801.37 1 0.4%
 
707.37 1 0.4%
 
679.63 1 0.4%
 

max_meses_servicos_all
Numeric

Distinct count154
Unique (%)58.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean2134.5
Minimum13.067
Maximum5099.1
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum13.067
5-th percentile53.447
Q1257.33
Median490.43
Q35015
95-th percentile5015
Maximum5099.1
Range5086
Interquartile range4757.6

Descriptive statistics

Standard deviation2311.3
Coef of variation1.0828
Kurtosis-1.7977
Mean2134.5
MAD2245.2
Skewness0.44911
Sum5.6564e+05
Variance5.3422e+06
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 13.06666667 251.51666667 268.21666667 579.1 662.26666667 2847.3 5039.83333333 5099.06666667], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
5015 91 34.3%
 
5099.1 6 2.3%
 
5064.7 5 1.9%
 
265.63 4 1.5%
 
265.67 4 1.5%
 
113.53 2 0.8%
 
481.83 2 0.8%
 
373.27 2 0.8%
 
387.43 2 0.8%
 
50.6 2 0.8%
 
Other values (144) 145 54.7%
 

Minimum 5 values

ValueCountFrequency (%) 
13.067 1 0.4%
 
26.233 1 0.4%
 
29.3 1 0.4%
 
29.367 1 0.4%
 
30.4 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
5099.1 6 2.3%
 
5065.7 1 0.4%
 
5064.7 5 1.9%
 
5015 91 34.3%
 
679.63 1 0.4%
 

max_vl_folha_coligados
Numeric

Distinct count56
Unique (%)21.1%
Missing (%)78.1%
Missing (n)207
Infinite (%)0.0%
Infinite (n)0
Mean2.87e+07
Minimum0
Maximum2.0771e+08
Zeros (%)0.4%
Mini histogram

Quantile statistics

Minimum0
5-th percentile1.4115e+05
Q18.191e+05
Median7.8716e+06
Q33.1667e+07
95-th percentile1.6598e+08
Maximum2.0771e+08
Range2.0771e+08
Interquartile range3.0848e+07

Descriptive statistics

Standard deviation5.0411e+07
Coef of variation1.7565
Kurtosis5.4277
Mean2.87e+07
MAD3.39e+07
Skewness2.4373
Sum1.6646e+09
Variance2.5413e+15
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2.4728e+05 3 1.1%
 
3.7092e+05 2 0.8%
 
1.3003e+07 1 0.4%
 
1.2343e+08 1 0.4%
 
7.5131e+07 1 0.4%
 
8.5310e+06 1 0.4%
 
3.3959e+07 1 0.4%
 
4.3953e+07 1 0.4%
 
8.2426e+06 1 0.4%
 
4.2243e+06 1 0.4%
 
Other values (45) 45 17.0%
 
(Missing) 207 78.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1 0.4%
 
61819 1 0.4%
 
1.2364e+05 1 0.4%
 
1.4424e+05 1 0.4%
 
1.8546e+05 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
2.0771e+08 1 0.4%
 
2.0392e+08 1 0.4%
 
1.7157e+08 1 0.4%
 
1.65e+08 1 0.4%
 
1.2343e+08 1 0.4%
 

max_vl_folha_coligados_gp
Numeric

Distinct count58
Unique (%)21.9%
Missing (%)77.7%
Missing (n)206
Infinite (%)0.0%
Infinite (n)0
Mean7.5771e+07
Minimum61819
Maximum1.3901e+09
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum61819
5-th percentile1.8134e+05
Q11.1127e+06
Median8.2426e+06
Q34.1161e+07
95-th percentile2.8546e+08
Maximum1.3901e+09
Range1.3901e+09
Interquartile range4.0049e+07

Descriptive statistics

Standard deviation2.2829e+08
Coef of variation3.0129
Kurtosis22.01
Mean7.5771e+07
MAD1.0578e+08
Skewness4.5546
Sum4.4705e+09
Variance5.2115e+16
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2.4728e+05 3 1.1%
 
6.8207e+06 1 0.4%
 
1.2343e+08 1 0.4%
 
8.5310e+06 1 0.4%
 
4.3953e+07 1 0.4%
 
8.2426e+06 1 0.4%
 
7.8304e+05 1 0.4%
 
2.8849e+05 1 0.4%
 
1.2362e+08 1 0.4%
 
4.4736e+07 1 0.4%
 
Other values (47) 47 17.7%
 
(Missing) 206 77.7%
 

Minimum 5 values

ValueCountFrequency (%) 
61819 1 0.4%
 
1.2364e+05 1 0.4%
 
1.4424e+05 1 0.4%
 
1.8546e+05 1 0.4%
 
2.4728e+05 3 1.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1.3901e+09 1 0.4%
 
8.9807e+08 1 0.4%
 
6.783e+08 1 0.4%
 
2.4182e+08 1 0.4%
 
1.7742e+08 1 0.4%
 

media_faturamento_est_coligados
Highly correlated

This variable is highly correlated with max_faturamento_est_coligados and should be ignored for analysis

Correlation0.90753

media_faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with media_faturamento_est_coligados and should be ignored for analysis

Correlation0.94656

media_filiais_coligados
Numeric

Distinct count20
Unique (%)7.5%
Missing (%)86.4%
Missing (n)229
Infinite (%)0.0%
Infinite (n)0
Mean8.004
Minimum1
Maximum63
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11.5
Median2.1
Q34.125
95-th percentile41.125
Maximum63
Range62
Interquartile range2.625

Descriptive statistics

Standard deviation14.361
Coef of variation1.7942
Kurtosis7.1143
Mean8.004
MAD9.2683
Skewness2.7226
Sum288.14
Variance206.22
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 9 3.4%
 
2 8 3.0%
 
4 3 1.1%
 
2.5556 1 0.4%
 
10 1 0.4%
 
25 1 0.4%
 
2.5 1 0.4%
 
63 1 0.4%
 
6 1 0.4%
 
1.6667 1 0.4%
 
Other values (9) 9 3.4%
 
(Missing) 229 86.4%
 

Minimum 5 values

ValueCountFrequency (%) 
1 9 3.4%
 
1.6667 1 0.4%
 
2 8 3.0%
 
2.2 1 0.4%
 
2.3636 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
63 1 0.4%
 
49 1 0.4%
 
38.5 1 0.4%
 
25 1 0.4%
 
24 1 0.4%
 

media_funcionarios_coligados_gp
Numeric

Distinct count56
Unique (%)21.1%
Missing (%)76.2%
Missing (n)202
Infinite (%)0.0%
Infinite (n)0
Mean243.25
Minimum0
Maximum4398.6
Zeros (%)1.5%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0.1
Q17.6667
Median45
Q3150
95-th percentile846.66
Maximum4398.6
Range4398.6
Interquartile range142.33

Descriptive statistics

Standard deviation652.23
Coef of variation2.6814
Kurtosis28.057
Mean243.25
MAD311.8
Skewness4.9629
Sum15324
Variance4.2541e+05
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
4 4 1.5%
 
0 4 1.5%
 
10 2 0.8%
 
3 2 0.8%
 
25 1 0.4%
 
45 1 0.4%
 
119 1 0.4%
 
28.25 1 0.4%
 
77 1 0.4%
 
37 1 0.4%
 
Other values (45) 45 17.0%
 
(Missing) 202 76.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 4 1.5%
 
1 1 0.4%
 
2 1 0.4%
 
3 2 0.8%
 
4 4 1.5%
 

Maximum 5 values

ValueCountFrequency (%) 
4398.6 1 0.4%
 
2112 1 0.4%
 
1878.3 1 0.4%
 
851.43 1 0.4%
 
803.68 1 0.4%
 

media_meses_servicos
Numeric

Distinct count265
Unique (%)100.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean129.43
Minimum5.947
Maximum353.95
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum5.947
5-th percentile22.162
Q158.735
Median138.39
Q3182.09
95-th percentile234.58
Maximum353.95
Range348.01
Interquartile range123.36

Descriptive statistics

Standard deviation73.441
Coef of variation0.5674
Kurtosis-0.64313
Mean129.43
MAD62.156
Skewness0.14637
Sum34300
Variance5393.6
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 5.94700521 71.14189247 131.75648398 230.94920855 353.95493827], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
47.866 1 0.4%
 
146.84 1 0.4%
 
30.829 1 0.4%
 
40.411 1 0.4%
 
235.27 1 0.4%
 
48.28 1 0.4%
 
160.5 1 0.4%
 
58.735 1 0.4%
 
202.02 1 0.4%
 
201.51 1 0.4%
 
Other values (255) 255 96.2%
 

Minimum 5 values

ValueCountFrequency (%) 
5.947 1 0.4%
 
10.966 1 0.4%
 
11.984 1 0.4%
 
14.42 1 0.4%
 
15.148 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
353.95 1 0.4%
 
319.02 1 0.4%
 
313.49 1 0.4%
 
310.82 1 0.4%
 
288.75 1 0.4%
 

media_meses_servicos_all
Numeric

Distinct count265
Unique (%)100.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean120.28
Minimum6.1155
Maximum576.62
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum6.1155
5-th percentile16.111
Q139.685
Median110.73
Q3173.47
95-th percentile260.45
Maximum576.62
Range570.51
Interquartile range133.79

Descriptive statistics

Standard deviation92.931
Coef of variation0.7726
Kurtosis3.981
Mean120.28
MAD71.725
Skewness1.4537
Sum31875
Variance8636.2
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 6.11545338 40.25856594 226.94763241 288.83190072 576.62406367], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
295.41 1 0.4%
 
119.62 1 0.4%
 
35.878 1 0.4%
 
192.4 1 0.4%
 
93.25 1 0.4%
 
137.19 1 0.4%
 
30.172 1 0.4%
 
113.89 1 0.4%
 
94.247 1 0.4%
 
152.47 1 0.4%
 
Other values (255) 255 96.2%
 

Minimum 5 values

ValueCountFrequency (%) 
6.1155 1 0.4%
 
8.897 1 0.4%
 
8.9103 1 0.4%
 
9.2744 1 0.4%
 
10.881 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
576.62 1 0.4%
 
552.77 1 0.4%
 
519.21 1 0.4%
 
367.72 1 0.4%
 
361.37 1 0.4%
 

media_vl_folha_coligados
Numeric

Distinct count57
Unique (%)21.5%
Missing (%)78.1%
Missing (n)207
Infinite (%)0.0%
Infinite (n)0
Mean9.1428e+06
Minimum0
Maximum1.2343e+08
Zeros (%)0.4%
Mini histogram

Quantile statistics

Minimum0
5-th percentile1.4115e+05
Q14.894e+05
Median4.2346e+06
Q31.0169e+07
95-th percentile2.6651e+07
Maximum1.2343e+08
Range1.2343e+08
Interquartile range9.6799e+06

Descriptive statistics

Standard deviation1.773e+07
Coef of variation1.9392
Kurtosis30.815
Mean9.1428e+06
MAD9.4667e+06
Skewness5.0062
Sum5.3028e+08
Variance3.1434e+14
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2.4728e+05 3 1.1%
 
5.9759e+05 1 0.4%
 
2.1637e+05 1 0.4%
 
4.2449e+06 1 0.4%
 
4.2243e+06 1 0.4%
 
1.3992e+07 1 0.4%
 
2.72e+06 1 0.4%
 
5.4727e+06 1 0.4%
 
61819 1 0.4%
 
3.6696e+07 1 0.4%
 
Other values (46) 46 17.4%
 
(Missing) 207 78.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1 0.4%
 
61819 1 0.4%
 
1.2364e+05 1 0.4%
 
1.4424e+05 1 0.4%
 
1.8546e+05 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
1.2343e+08 1 0.4%
 
3.8369e+07 1 0.4%
 
3.6696e+07 1 0.4%
 
2.4878e+07 1 0.4%
 
2.4383e+07 1 0.4%
 

media_vl_folha_coligados_gp
Numeric

Distinct count58
Unique (%)21.9%
Missing (%)77.7%
Missing (n)206
Infinite (%)0.0%
Infinite (n)0
Mean1.4371e+07
Minimum61819
Maximum1.2343e+08
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum61819
5-th percentile1.8134e+05
Q17.238e+05
Median4.7189e+06
Q31.1292e+07
95-th percentile6.3809e+07
Maximum1.2343e+08
Range1.2337e+08
Interquartile range1.0569e+07

Descriptive statistics

Standard deviation2.5761e+07
Coef of variation1.7925
Kurtosis8.0327
Mean1.4371e+07
MAD1.6633e+07
Skewness2.788
Sum8.4791e+08
Variance6.6365e+14
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2.4728e+05 3 1.1%
 
2.0716e+07 1 0.4%
 
8.5310e+06 1 0.4%
 
7.8304e+05 1 0.4%
 
1.8127e+07 1 0.4%
 
2.1637e+05 1 0.4%
 
6.1812e+07 1 0.4%
 
2.72e+06 1 0.4%
 
61819 1 0.4%
 
8.7989e+06 1 0.4%
 
Other values (47) 47 17.7%
 
(Missing) 206 77.7%
 

Minimum 5 values

ValueCountFrequency (%) 
61819 1 0.4%
 
1.2364e+05 1 0.4%
 
1.4424e+05 1 0.4%
 
1.8546e+05 1 0.4%
 
2.1637e+05 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
1.2343e+08 1 0.4%
 
1.1024e+08 1 0.4%
 
8.1778e+07 1 0.4%
 
6.1812e+07 1 0.4%
 
5.2856e+07 1 0.4%
 

meses_ultima_contratacaco
Numeric

Distinct count137
Unique (%)51.7%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean19.388
Minimum1.9667
Maximum112.17
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1.9667
5-th percentile2.0667
Q12.9333
Median23.2
Q327.9
95-th percentile42.513
Maximum112.17
Range110.2
Interquartile range24.967

Descriptive statistics

Standard deviation16.074
Coef of variation0.82905
Kurtosis4.6061
Mean19.388
MAD12.865
Skewness1.2956
Sum5137.8
Variance258.36
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 1.96666667 3.06666667 4.98333333 22.18333333 23.18333333 ... 25.06666667 25.25 31.56666667 46.53333333 112.16666667], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
2.9333 16 6.0%
 
23.2 13 4.9%
 
24.2 10 3.8%
 
2.0667 10 3.8%
 
2.3 7 2.6%
 
30.333 6 2.3%
 
2.5333 6 2.3%
 
2.2 5 1.9%
 
2.0333 5 1.9%
 
28.3 5 1.9%
 
Other values (127) 182 68.7%
 

Minimum 5 values

ValueCountFrequency (%) 
1.9667 3 1.1%
 
2 1 0.4%
 
2.0333 5 1.9%
 
2.0667 10 3.8%
 
2.1667 2 0.8%
 

Maximum 5 values

ValueCountFrequency (%) 
112.17 1 0.4%
 
88.167 1 0.4%
 
70.867 1 0.4%
 
68.9 1 0.4%
 
65.833 1 0.4%
 

min_faturamento_est_coligados
Numeric

Distinct count26
Unique (%)9.8%
Missing (%)72.1%
Missing (n)191
Infinite (%)0.0%
Infinite (n)0
Mean1.9014e+06
Minimum50000
Maximum3.2507e+07
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum50000
5-th percentile1.2364e+05
Q12.1e+05
Median2.1e+05
Q34.9455e+05
95-th percentile1.6596e+07
Maximum3.2507e+07
Range3.2457e+07
Interquartile range2.8455e+05

Descriptive statistics

Standard deviation5.7207e+06
Coef of variation3.0087
Kurtosis15.212
Mean1.9014e+06
MAD2.851e+06
Skewness3.8983
Sum1.407e+08
Variance3.2726e+13
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2.1e+05 39 14.7%
 
1.2364e+05 8 3.0%
 
4.9455e+05 3 1.1%
 
6.1819e+05 2 0.8%
 
9.3e+05 2 0.8%
 
2.1328e+07 1 0.4%
 
1.1952e+06 1 0.4%
 
3.0085e+06 1 0.4%
 
3.2507e+07 1 0.4%
 
1.6434e+07 1 0.4%
 
Other values (15) 15 5.7%
 
(Missing) 191 72.1%
 

Minimum 5 values

ValueCountFrequency (%) 
50000 1 0.4%
 
1.2364e+05 8 3.0%
 
1.6485e+05 1 0.4%
 
1.8546e+05 1 0.4%
 
2.0606e+05 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
3.2507e+07 1 0.4%
 
2.3182e+07 1 0.4%
 
2.1328e+07 1 0.4%
 
1.6897e+07 1 0.4%
 
1.6434e+07 1 0.4%
 

min_faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with min_faturamento_est_coligados and should be ignored for analysis

Correlation0.98448

min_filiais_coligados
Numeric

Distinct count8
Unique (%)3.0%
Missing (%)86.4%
Missing (n)229
Infinite (%)0.0%
Infinite (n)0
Mean2.9722
Minimum1
Maximum49
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q32
95-th percentile5.25
Maximum49
Range48
Interquartile range1

Descriptive statistics

Standard deviation7.9839
Coef of variation2.6862
Kurtosis34.197
Mean2.9722
MAD2.8997
Skewness5.7876
Sum107
Variance63.742
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%) 
1 24 9.1%
 
2 5 1.9%
 
3 3 1.1%
 
49 1 0.4%
 
4 1 0.4%
 
6 1 0.4%
 
5 1 0.4%
 
(Missing) 229 86.4%
 

Minimum 5 values

ValueCountFrequency (%) 
1 24 9.1%
 
2 5 1.9%
 
3 3 1.1%
 
4 1 0.4%
 
5 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
49 1 0.4%
 
6 1 0.4%
 
5 1 0.4%
 
4 1 0.4%
 
3 3 1.1%
 

min_funcionarios_coligados_gp
Highly correlated

This variable is highly correlated with min_filiais_coligados and should be ignored for analysis

Correlation0.91607

min_meses_servicos
Highly correlated

This variable is highly correlated with meses_ultima_contratacaco and should be ignored for analysis

Correlation0.95675

min_meses_servicos_all
Numeric

Distinct count125
Unique (%)47.2%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1.3312
Minimum-11.7
Maximum66.933
Zeros (%)7.2%
Mini histogram

Quantile statistics

Minimum-11.7
5-th percentile-6.1
Q1-0.63333
Median0
Q31.6667
95-th percentile10.873
Maximum66.933
Range78.633
Interquartile range2.3

Descriptive statistics

Standard deviation7.1
Coef of variation5.3335
Kurtosis33.658
Mean1.3312
MAD3.5908
Skewness4.5789
Sum352.77
Variance50.41
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[-1.17000000e+01 -1.15000000e+00 -7.50000000e-01 -5.00000000e-02 6.66666667e-02 9.66666667e-01 1.05000000e+00 3.13333333e+00 1.28500000e+01 6.69333333e+01], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 19 7.2%
 
1 14 5.3%
 
-0.53333 9 3.4%
 
-0.033333 8 3.0%
 
-0.73333 6 2.3%
 
0.2 6 2.3%
 
-0.4 5 1.9%
 
8.1333 5 1.9%
 
2.0333 5 1.9%
 
-0.56667 4 1.5%
 
Other values (115) 184 69.4%
 

Minimum 5 values

ValueCountFrequency (%) 
-11.7 1 0.4%
 
-11.2 2 0.8%
 
-11.167 1 0.4%
 
-10.167 1 0.4%
 
-9.8333 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
66.933 1 0.4%
 
44.2 1 0.4%
 
27.7 1 0.4%
 
27.5 1 0.4%
 
26.7 1 0.4%
 

min_vl_folha_coligados
Highly correlated

This variable is highly correlated with min_funcionarios_coligados_gp and should be ignored for analysis

Correlation0.99898

min_vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with min_vl_folha_coligados and should be ignored for analysis

Correlation0.99917

natureza_juridica_macro
Categorical

Distinct count4
Unique (%)1.5%
Missing (%)0.0%
Missing (n)0
OUTROS
128
ENTIDADES EMPRESARIAIS
73
ADMINISTRACAO PUBLICA
47
ValueCountFrequency (%) 
OUTROS 128 48.3%
 
ENTIDADES EMPRESARIAIS 73 27.5%
 
ADMINISTRACAO PUBLICA 47 17.7%
 
ENTIDADES SEM FINS LUCRATIVOS 17 6.4%
 
Max length29
Mean length14.543
Min length6
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_divisao
Categorical

Distinct count26
Unique (%)9.8%
Missing (%)0.0%
Missing (n)0
ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL
150
EDUCACAO
 
22
SERVICOS PARA EDIFICIOS E ATIVIDADES PAISAGISTICAS
 
18
Other values (23)
75
ValueCountFrequency (%) 
ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL 150 56.6%
 
EDUCACAO 22 8.3%
 
SERVICOS PARA EDIFICIOS E ATIVIDADES PAISAGISTICAS 18 6.8%
 
ATIVIDADES DE ATENCAO A SAUDE HUMANA 12 4.5%
 
TRANSPORTE TERRESTRE 12 4.5%
 
SELECAO AGENCIAMENTO E LOCACAO DE MAO DE OBRA 6 2.3%
 
ALIMENTACAO 4 1.5%
 
SERVICOS DE ESCRITORIO DE APOIO ADMINISTRATIVO E OUTROS SERVICOS PRESTADOS PRINCIPALMENTE AS EMPRESAS 4 1.5%
 
SERVICOS DE ARQUITETURA E ENGENHARIA TESTES E ANALISES TECNICAS 4 1.5%
 
ATIVIDADES DE VIGILANCIA SEGURANCA E INVESTIGACAO 4 1.5%
 
Other values (16) 29 10.9%
 
Max length120
Mean length43.509
Min length8
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_meso_regiao
Categorical

Distinct count20
Unique (%)7.5%
Missing (%)9.1%
Missing (n)24
NORTE MARANHENSE
41
CENTRO AMAZONENSE
39
CENTRO NORTE PIAUIENSE
31
Other values (16)
130
(Missing)
 
24
ValueCountFrequency (%) 
NORTE MARANHENSE 41 15.5%
 
CENTRO AMAZONENSE 39 14.7%
 
CENTRO NORTE PIAUIENSE 31 11.7%
 
LESTE POTIGUAR 23 8.7%
 
VALE DO ACRE 21 7.9%
 
OESTE POTIGUAR 13 4.9%
 
CENTRO MARANHENSE 11 4.2%
 
SUDESTE PIAUIENSE 11 4.2%
 
OESTE MARANHENSE 10 3.8%
 
AGRESTE POTIGUAR 8 3.0%
 
Other values (9) 33 12.5%
 
(Missing) 24 9.1%
 
Max length22
Mean length15.162
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_micro_regiao
Categorical

Distinct count57
Unique (%)21.5%
Missing (%)9.1%
Missing (n)24
MANAUS
38
AGLOMERACAO URBANA DE SAO LUIS
32
TERESINA
 
21
Other values (53)
150
(Missing)
 
24
ValueCountFrequency (%) 
MANAUS 38 14.3%
 
AGLOMERACAO URBANA DE SAO LUIS 32 12.1%
 
TERESINA 21 7.9%
 
RIO BRANCO 19 7.2%
 
NATAL 18 6.8%
 
PICOS 6 2.3%
 
PINDARE 6 2.3%
 
MEDIO MEARIM 6 2.3%
 
ALTO MEDIO CANINDE 5 1.9%
 
CAMPO MAIOR 5 1.9%
 
Other values (46) 85 32.1%
 
(Missing) 24 9.1%
 
Max length30
Mean length12.347
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_segmento
Categorical

Distinct count13
Unique (%)4.9%
Missing (%)0.0%
Missing (n)0
ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL
150
ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARES
35
EDUCACAO
 
22
Other values (10)
58
ValueCountFrequency (%) 
ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL 150 56.6%
 
ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARES 35 13.2%
 
EDUCACAO 22 8.3%
 
TRANSPORTE ARMAZENAGEM E CORREIO 14 5.3%
 
SAUDE HUMANA E SERVICOS SOCIAIS 14 5.3%
 
ALOJAMENTO E ALIMENTACAO 5 1.9%
 
ATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS 5 1.9%
 
ATIVIDADES FINANCEIRAS DE SEGUROS E SERVICOS RELACIONADOS 5 1.9%
 
AGUA ESGOTO ATIVIDADES DE GESTAO DE RESIDUOS E DESCONTAMINACAO 5 1.9%
 
OUTRAS ATIVIDADES DE SERVICOS 4 1.5%
 
Other values (3) 6 2.3%
 
Max length62
Mean length42.626
Min length8
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nu_meses_rescencia
Numeric

Distinct count12
Unique (%)4.5%
Missing (%)0.4%
Missing (n)1
Infinite (%)0.0%
Infinite (n)0
Mean24.739
Minimum9
Maximum49
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum9
5-th percentile22
Q123
Median23
Q323
95-th percentile48
Maximum49
Range40
Interquartile range0

Descriptive statistics

Standard deviation6.2413
Coef of variation0.25229
Kurtosis9.9073
Mean24.739
MAD3.1925
Skewness3.2904
Sum6531
Variance38.954
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
23 205 77.4%
 
48 15 5.7%
 
26 13 4.9%
 
22 12 4.5%
 
24 7 2.6%
 
27 4 1.5%
 
21 3 1.1%
 
25 2 0.8%
 
9 1 0.4%
 
47 1 0.4%
 

Minimum 5 values

ValueCountFrequency (%) 
9 1 0.4%
 
21 3 1.1%
 
22 12 4.5%
 
23 205 77.4%
 
24 7 2.6%
 

Maximum 5 values

ValueCountFrequency (%) 
49 1 0.4%
 
48 15 5.7%
 
47 1 0.4%
 
27 4 1.5%
 
26 13 4.9%
 

percent_func_genero_fem
Numeric

Distinct count261
Unique (%)98.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean52.979
Minimum0.36
Maximum86.06
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum0.36
5-th percentile13.274
Q143.38
Median57.51
Q367.71
95-th percentile76.994
Maximum86.06
Range85.7
Interquartile range24.33

Descriptive statistics

Standard deviation19.045
Coef of variation0.35948
Kurtosis0.12131
Mean52.979
MAD15.197
Skewness-0.85478
Sum14040
Variance362.7
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0.36 30.935 47.245 73.815 86.06 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
63.38 2 0.8%
 
72.93 2 0.8%
 
69.21 2 0.8%
 
50 2 0.8%
 
68.02 1 0.4%
 
49.35 1 0.4%
 
52.31 1 0.4%
 
68.63 1 0.4%
 
63.36 1 0.4%
 
74.03 1 0.4%
 
Other values (251) 251 94.7%
 

Minimum 5 values

ValueCountFrequency (%) 
0.36 1 0.4%
 
3 1 0.4%
 
3.47 1 0.4%
 
4.74 1 0.4%
 
4.98 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
86.06 1 0.4%
 
84.44 1 0.4%
 
83.22 1 0.4%
 
83.1 1 0.4%
 
82.91 1 0.4%
 

percent_func_genero_masc
Numeric

Distinct count261
Unique (%)98.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean47.021
Minimum13.94
Maximum99.64
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum13.94
5-th percentile23.006
Q132.29
Median42.49
Q356.62
95-th percentile86.726
Maximum99.64
Range85.7
Interquartile range24.33

Descriptive statistics

Standard deviation19.045
Coef of variation0.40503
Kurtosis0.12131
Mean47.021
MAD15.197
Skewness0.85478
Sum12460
Variance362.7
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[13.94 26.185 52.755 69.065 99.64 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
27.07 2 0.8%
 
36.62 2 0.8%
 
30.79 2 0.8%
 
50 2 0.8%
 
52.76 1 0.4%
 
16.78 1 0.4%
 
64.01 1 0.4%
 
74.22 1 0.4%
 
36.64 1 0.4%
 
50.65 1 0.4%
 
Other values (251) 251 94.7%
 

Minimum 5 values

ValueCountFrequency (%) 
13.94 1 0.4%
 
15.56 1 0.4%
 
16.78 1 0.4%
 
16.9 1 0.4%
 
17.09 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
99.64 1 0.4%
 
97 1 0.4%
 
96.53 1 0.4%
 
95.26 1 0.4%
 
95.02 1 0.4%
 

qt_admitidos
Numeric

Distinct count241
Unique (%)90.9%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean915.86
Minimum83
Maximum7961
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum83
5-th percentile177
Q1355
Median582
Q3983
95-th percentile2839.4
Maximum7961
Range7878
Interquartile range628

Descriptive statistics

Standard deviation1092.2
Coef of variation1.1925
Kurtosis16.82
Mean915.86
MAD641.17
Skewness3.6757
Sum2.427e+05
Variance1.1929e+06
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 83. 590.5 1045.5 1770. 3398.5 7961. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
246 2 0.8%
 
582 2 0.8%
 
1044 2 0.8%
 
410 2 0.8%
 
355 2 0.8%
 
1484 2 0.8%
 
1160 2 0.8%
 
1212 2 0.8%
 
340 2 0.8%
 
243 2 0.8%
 
Other values (231) 245 92.5%
 

Minimum 5 values

ValueCountFrequency (%) 
83 1 0.4%
 
96 1 0.4%
 
120 1 0.4%
 
130 1 0.4%
 
136 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
7961 1 0.4%
 
7803 1 0.4%
 
6262 1 0.4%
 
6103 1 0.4%
 
5340 1 0.4%
 

qt_admitidos_12meses
Numeric

Distinct count73
Unique (%)27.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean28.064
Minimum0
Maximum782
Zeros (%)61.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q327
95-th percentile132.2
Maximum782
Range782
Interquartile range27

Descriptive statistics

Standard deviation73.041
Coef of variation2.6026
Kurtosis48.796
Mean28.064
MAD38.542
Skewness5.9088
Sum7437
Variance5335
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[0.000e+00 5.000e-01 3.850e+01 9.850e+01 2.575e+02 7.820e+02], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 162 61.1%
 
35 3 1.1%
 
8 3 1.1%
 
1 3 1.1%
 
18 3 1.1%
 
87 3 1.1%
 
13 3 1.1%
 
12 3 1.1%
 
74 2 0.8%
 
14 2 0.8%
 
Other values (63) 78 29.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 162 61.1%
 
1 3 1.1%
 
2 2 0.8%
 
4 1 0.4%
 
6 2 0.8%
 

Maximum 5 values

ValueCountFrequency (%) 
782 1 0.4%
 
465 1 0.4%
 
332 1 0.4%
 
259 1 0.4%
 
256 1 0.4%
 

qt_alteracao_socio_180d
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_alteracao_socio_365d
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_alteracao_socio_90d
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_alteracao_socio_total
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_art
Numeric

Distinct count39
Unique (%)14.7%
Missing (%)50.9%
Missing (n)135
Infinite (%)0.0%
Infinite (n)0
Mean21.515
Minimum1
Maximum912
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q12.25
Median6
Q314
95-th percentile44
Maximum912
Range911
Interquartile range11.75

Descriptive statistics

Standard deviation87.8
Coef of variation4.0808
Kurtosis86.519
Mean21.515
MAD25.256
Skewness8.9824
Sum2797
Variance7708.9
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 20 7.5%
 
3 13 4.9%
 
2 13 4.9%
 
6 10 3.8%
 
5 9 3.4%
 
13 6 2.3%
 
7 6 2.3%
 
4 5 1.9%
 
14 4 1.5%
 
12 3 1.1%
 
Other values (28) 41 15.5%
 
(Missing) 135 50.9%
 

Minimum 5 values

ValueCountFrequency (%) 
1 20 7.5%
 
2 13 4.9%
 
3 13 4.9%
 
4 5 1.9%
 
5 9 3.4%
 

Maximum 5 values

ValueCountFrequency (%) 
912 1 0.4%
 
426 1 0.4%
 
88 1 0.4%
 
51 2 0.8%
 
45 1 0.4%
 

qt_coligadas
Numeric

Distinct count21
Unique (%)7.9%
Missing (%)71.3%
Missing (n)189
Infinite (%)0.0%
Infinite (n)0
Mean6.9737
Minimum1
Maximum57
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median2
Q36
95-th percentile36.5
Maximum57
Range56
Interquartile range5

Descriptive statistics

Standard deviation11.03
Coef of variation1.5816
Kurtosis7.0833
Mean6.9737
MAD7.2749
Skewness2.6335
Sum530
Variance121.65
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 27 10.2%
 
2 14 5.3%
 
3 7 2.6%
 
6 7 2.6%
 
4 3 1.1%
 
15 2 0.8%
 
8 2 0.8%
 
17 2 0.8%
 
9 1 0.4%
 
36 1 0.4%
 
Other values (10) 10 3.8%
 
(Missing) 189 71.3%
 

Minimum 5 values

ValueCountFrequency (%) 
1 27 10.2%
 
2 14 5.3%
 
3 7 2.6%
 
4 3 1.1%
 
5 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
57 1 0.4%
 
40 1 0.4%
 
39 1 0.4%
 
38 1 0.4%
 
36 1 0.4%
 

qt_coligados
Highly correlated

This variable is highly correlated with qt_coligadas and should be ignored for analysis

Correlation1

qt_coligados_agropecuaria
Categorical

Distinct count5
Unique (%)1.9%
Missing (%)71.3%
Missing (n)189
0
70
1
 
3
2
 
2
(Missing)
189
ValueCountFrequency (%) 
0 70 26.4%
 
1 3 1.1%
 
2 2 0.8%
 
4 1 0.4%
 
(Missing) 189 71.3%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

qt_coligados_atividade_alto
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_atividade_baixo
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_atividade_inativo
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_atividade_medio
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_atividade_mt_baixo
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_ativo
Highly correlated

This variable is highly correlated with qt_coligados and should be ignored for analysis

Correlation0.99975

qt_coligados_baixada
Highly correlated

This variable is highly correlated with max_funcionarios_coligados_gp and should be ignored for analysis

Correlation0.97185

qt_coligados_ccivil
Categorical

Distinct count5
Unique (%)1.9%
Missing (%)71.3%
Missing (n)189
0
68
1
 
5
2
 
2
(Missing)
189
ValueCountFrequency (%) 
0 68 25.7%
 
1 5 1.9%
 
2 2 0.8%
 
3 1 0.4%
 
(Missing) 189 71.3%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

qt_coligados_centro
Numeric

Distinct count6
Unique (%)2.3%
Missing (%)71.3%
Missing (n)189
Infinite (%)0.0%
Infinite (n)0
Mean0.31579
Minimum0
Maximum8
Zeros (%)25.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile1
Maximum8
Range8
Interquartile range0

Descriptive statistics

Standard deviation1.2983
Coef of variation4.1113
Kurtosis25.694
Mean0.31579
MAD0.5651
Skewness5.0173
Sum24
Variance1.6856
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%) 
0 68 25.7%
 
1 5 1.9%
 
8 1 0.4%
 
4 1 0.4%
 
7 1 0.4%
 
(Missing) 189 71.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 68 25.7%
 
1 5 1.9%
 
4 1 0.4%
 
7 1 0.4%
 
8 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
8 1 0.4%
 
7 1 0.4%
 
4 1 0.4%
 
1 5 1.9%
 
0 68 25.7%
 

qt_coligados_comercio
Numeric

Distinct count9
Unique (%)3.4%
Missing (%)71.3%
Missing (n)189
Infinite (%)0.0%
Infinite (n)0
Mean1.0921
Minimum0
Maximum26
Zeros (%)17.4%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q31
95-th percentile4
Maximum26
Range26
Interquartile range1

Descriptive statistics

Standard deviation3.1546
Coef of variation2.8885
Kurtosis53.169
Mean1.0921
MAD1.356
Skewness6.8226
Sum83
Variance9.9514
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%) 
0 46 17.4%
 
1 14 5.3%
 
2 9 3.4%
 
4 2 0.8%
 
3 2 0.8%
 
6 1 0.4%
 
5 1 0.4%
 
26 1 0.4%
 
(Missing) 189 71.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 46 17.4%
 
1 14 5.3%
 
2 9 3.4%
 
3 2 0.8%
 
4 2 0.8%
 

Maximum 5 values

ValueCountFrequency (%) 
26 1 0.4%
 
6 1 0.4%
 
5 1 0.4%
 
4 2 0.8%
 
3 2 0.8%
 

qt_coligados_epp
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_exterior
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_inapta
Highly correlated

This variable is highly correlated with max_funcionarios_coligados_gp and should be ignored for analysis

Correlation0.97185

qt_coligados_industria
Numeric

Distinct count8
Unique (%)3.0%
Missing (%)71.3%
Missing (n)189
Infinite (%)0.0%
Infinite (n)0
Mean0.44737
Minimum0
Maximum10
Zeros (%)23.8%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile2.25
Maximum10
Range10
Interquartile range0

Descriptive statistics

Standard deviation1.4913
Coef of variation3.3334
Kurtosis25.378
Mean0.44737
MAD0.74169
Skewness4.7623
Sum34
Variance2.2239
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%) 
0 63 23.8%
 
1 8 3.0%
 
10 1 0.4%
 
3 1 0.4%
 
2 1 0.4%
 
5 1 0.4%
 
6 1 0.4%
 
(Missing) 189 71.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 63 23.8%
 
1 8 3.0%
 
2 1 0.4%
 
3 1 0.4%
 
5 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
10 1 0.4%
 
6 1 0.4%
 
5 1 0.4%
 
3 1 0.4%
 
2 1 0.4%
 

qt_coligados_ltda
Numeric

Distinct count6
Unique (%)2.3%
Missing (%)71.3%
Missing (n)189
Infinite (%)0.0%
Infinite (n)0
Mean0.26316
Minimum0
Maximum8
Zeros (%)26.0%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile1
Maximum8
Range8
Interquartile range0

Descriptive statistics

Standard deviation1.1704
Coef of variation4.4475
Kurtosis32.877
Mean0.26316
MAD0.47784
Skewness5.616
Sum20
Variance1.3698
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%) 
0 69 26.0%
 
1 4 1.5%
 
2 1 0.4%
 
8 1 0.4%
 
6 1 0.4%
 
(Missing) 189 71.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 69 26.0%
 
1 4 1.5%
 
2 1 0.4%
 
6 1 0.4%
 
8 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
8 1 0.4%
 
6 1 0.4%
 
2 1 0.4%
 
1 4 1.5%
 
0 69 26.0%
 

qt_coligados_matriz
Highly correlated

This variable is highly correlated with qt_coligados_ativo and should be ignored for analysis

Correlation0.9997

qt_coligados_me
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_mei
Boolean

Distinct count3
Unique (%)1.1%
Missing (%)71.3%
Missing (n)189
0
75
1
 
1
(Missing)
189
ValueCountFrequency (%) 
0 75 28.3%
 
1 1 0.4%
 
(Missing) 189 71.3%
 

qt_coligados_nordeste
Numeric

Distinct count14
Unique (%)5.3%
Missing (%)71.3%
Missing (n)189
Infinite (%)0.0%
Infinite (n)0
Mean2.6184
Minimum0
Maximum36
Zeros (%)11.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median1
Q32.25
95-th percentile9.75
Maximum36
Range36
Interquartile range2.25

Descriptive statistics

Standard deviation5.5377
Coef of variation2.1149
Kurtosis20.65
Mean2.6184
MAD3.0066
Skewness4.2072
Sum199
Variance30.666
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 31 11.7%
 
1 17 6.4%
 
2 9 3.4%
 
6 4 1.5%
 
3 4 1.5%
 
4 4 1.5%
 
36 1 0.4%
 
25 1 0.4%
 
12 1 0.4%
 
5 1 0.4%
 
Other values (3) 3 1.1%
 
(Missing) 189 71.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 31 11.7%
 
1 17 6.4%
 
2 9 3.4%
 
3 4 1.5%
 
4 4 1.5%
 

Maximum 5 values

ValueCountFrequency (%) 
36 1 0.4%
 
25 1 0.4%
 
17 1 0.4%
 
12 1 0.4%
 
9 1 0.4%
 

qt_coligados_norte
Numeric

Distinct count14
Unique (%)5.3%
Missing (%)71.3%
Missing (n)189
Infinite (%)0.0%
Infinite (n)0
Mean2.8816
Minimum0
Maximum52
Zeros (%)14.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q32
95-th percentile11.75
Maximum52
Range52
Interquartile range2

Descriptive statistics

Standard deviation7.5753
Coef of variation2.6289
Kurtosis26.258
Mean2.8816
MAD3.7898
Skewness4.7758
Sum219
Variance57.386
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 39 14.7%
 
1 14 5.3%
 
2 6 2.3%
 
5 3 1.1%
 
3 3 1.1%
 
4 2 0.8%
 
9 2 0.8%
 
6 2 0.8%
 
22 1 0.4%
 
11 1 0.4%
 
Other values (3) 3 1.1%
 
(Missing) 189 71.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 39 14.7%
 
1 14 5.3%
 
2 6 2.3%
 
3 3 1.1%
 
4 2 0.8%
 

Maximum 5 values

ValueCountFrequency (%) 
52 1 0.4%
 
32 1 0.4%
 
22 1 0.4%
 
14 1 0.4%
 
11 1 0.4%
 

qt_coligados_nula
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_sa
Numeric

Distinct count7
Unique (%)2.6%
Missing (%)71.3%
Missing (n)189
Infinite (%)0.0%
Infinite (n)0
Mean0.53947
Minimum0
Maximum10
Zeros (%)24.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile4
Maximum10
Range10
Interquartile range0

Descriptive statistics

Standard deviation1.7005
Coef of variation3.1522
Kurtosis16.01
Mean0.53947
MAD0.90859
Skewness3.882
Sum41
Variance2.8918
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%) 
0 64 24.2%
 
1 6 2.3%
 
4 3 1.1%
 
10 1 0.4%
 
7 1 0.4%
 
6 1 0.4%
 
(Missing) 189 71.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 64 24.2%
 
1 6 2.3%
 
4 3 1.1%
 
6 1 0.4%
 
7 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
10 1 0.4%
 
7 1 0.4%
 
6 1 0.4%
 
4 3 1.1%
 
1 6 2.3%
 

qt_coligados_serviço
Highly correlated

This variable is highly correlated with qt_coligados_matriz and should be ignored for analysis

Correlation0.92884

qt_coligados_sudeste
Numeric

Distinct count9
Unique (%)3.4%
Missing (%)71.3%
Missing (n)189
Infinite (%)0.0%
Infinite (n)0
Mean1.0132
Minimum0
Maximum28
Zeros (%)24.5%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile3.75
Maximum28
Range28
Interquartile range0

Descriptive statistics

Standard deviation4.0677
Coef of variation4.0149
Kurtosis31.879
Mean1.0132
MAD1.7334
Skewness5.4761
Sum77
Variance16.546
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%) 
0 65 24.5%
 
2 4 1.5%
 
3 2 0.8%
 
1 1 0.4%
 
8 1 0.4%
 
6 1 0.4%
 
28 1 0.4%
 
20 1 0.4%
 
(Missing) 189 71.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 65 24.5%
 
1 1 0.4%
 
2 4 1.5%
 
3 2 0.8%
 
6 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
28 1 0.4%
 
20 1 0.4%
 
8 1 0.4%
 
6 1 0.4%
 
3 2 0.8%
 

qt_coligados_sul
Highly correlated

This variable is highly correlated with qt_coligados_baixada and should be ignored for analysis

Correlation0.96129

qt_coligados_suspensa
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_desligados
Highly correlated

This variable is highly correlated with qt_admitidos and should be ignored for analysis

Correlation0.90561

qt_desligados_12meses
Numeric

Distinct count73
Unique (%)27.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean23.921
Minimum0
Maximum394
Zeros (%)60.0%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q321
95-th percentile125.6
Maximum394
Range394
Interquartile range21

Descriptive statistics

Standard deviation59.93
Coef of variation2.5054
Kurtosis18.15
Mean23.921
MAD32.957
Skewness4.0203
Sum6339
Variance3591.6
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 29.5 71. 394. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 159 60.0%
 
27 6 2.3%
 
9 5 1.9%
 
8 4 1.5%
 
22 4 1.5%
 
29 3 1.1%
 
7 3 1.1%
 
1 3 1.1%
 
11 3 1.1%
 
5 3 1.1%
 
Other values (63) 72 27.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 159 60.0%
 
1 3 1.1%
 
2 1 0.4%
 
3 2 0.8%
 
4 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
394 1 0.4%
 
379 1 0.4%
 
366 1 0.4%
 
345 1 0.4%
 
277 1 0.4%
 

qt_ex_funcionarios
Highly correlated

This variable is highly correlated with qt_desligados and should be ignored for analysis

Correlation1

qt_filiais
Numeric

Distinct count21
Unique (%)7.9%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean2.5547
Minimum0
Maximum172
Zeros (%)58.5%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q31
95-th percentile9.8
Maximum172
Range172
Interquartile range1

Descriptive statistics

Standard deviation12.01
Coef of variation4.7011
Kurtosis153.03
Mean2.5547
MAD3.6816
Skewness11.409
Sum677
Variance144.24
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 3.5 16.5 172. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 155 58.5%
 
1 53 20.0%
 
2 17 6.4%
 
3 10 3.8%
 
5 4 1.5%
 
7 3 1.1%
 
4 3 1.1%
 
10 3 1.1%
 
12 2 0.8%
 
9 2 0.8%
 
Other values (11) 13 4.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 155 58.5%
 
1 53 20.0%
 
2 17 6.4%
 
3 10 3.8%
 
4 3 1.1%
 

Maximum 5 values

ValueCountFrequency (%) 
172 1 0.4%
 
51 1 0.4%
 
49 1 0.4%
 
42 1 0.4%
 
33 1 0.4%
 

qt_funcionarios
Numeric

Distinct count231
Unique (%)87.2%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean468.6
Minimum68
Maximum3919
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum68
5-th percentile116
Q1188
Median313
Q3539
95-th percentile1321.2
Maximum3919
Range3851
Interquartile range351

Descriptive statistics

Standard deviation494.57
Coef of variation1.0554
Kurtosis16.016
Mean468.6
MAD310.06
Skewness3.4417
Sum1.2418e+05
Variance2.446e+05
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 68. 117.5 233.5 549.5 902.5 1927.5 3919. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
349 2 0.8%
 
353 2 0.8%
 
378 2 0.8%
 
677 2 0.8%
 
219 2 0.8%
 
188 2 0.8%
 
186 2 0.8%
 
199 2 0.8%
 
317 2 0.8%
 
212 2 0.8%
 
Other values (221) 245 92.5%
 

Minimum 5 values

ValueCountFrequency (%) 
68 1 0.4%
 
76 1 0.4%
 
82 1 0.4%
 
83 1 0.4%
 
85 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
3919 1 0.4%
 
3172 1 0.4%
 
3104 1 0.4%
 
2669 1 0.4%
 
1936 1 0.4%
 

qt_funcionarios_12meses
Highly correlated

This variable is highly correlated with qt_funcionarios and should be ignored for analysis

Correlation0.99487

qt_funcionarios_24meses
Highly correlated

This variable is highly correlated with qt_funcionarios_12meses and should be ignored for analysis

Correlation0.96889

qt_funcionarios_coligados
Numeric

Distinct count53
Unique (%)20.0%
Missing (%)76.2%
Missing (n)202
Infinite (%)0.0%
Infinite (n)0
Mean551.03
Minimum0
Maximum4770
Zeros (%)1.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q110.5
Median112
Q3510.5
95-th percentile3090.1
Maximum4770
Range4770
Interquartile range500

Descriptive statistics

Standard deviation1079.4
Coef of variation1.9588
Kurtosis7.1191
Mean551.03
MAD685.38
Skewness2.7314
Sum34715
Variance1.1651e+06
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 5 1.9%
 
4 3 1.1%
 
23 2 0.8%
 
3 2 0.8%
 
1 2 0.8%
 
11 2 0.8%
 
617 2 0.8%
 
54 1 0.4%
 
152 1 0.4%
 
312 1 0.4%
 
Other values (42) 42 15.8%
 
(Missing) 202 76.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 5 1.9%
 
1 2 0.8%
 
2 1 0.4%
 
3 2 0.8%
 
4 3 1.1%
 

Maximum 5 values

ValueCountFrequency (%) 
4770 1 0.4%
 
4463 1 0.4%
 
4124 1 0.4%
 
3183 1 0.4%
 
2254 1 0.4%
 

qt_funcionarios_coligados_gp
Highly correlated

This variable is highly correlated with qt_coligados_inapta and should be ignored for analysis

Correlation0.92314

qt_funcionarios_grupo
Highly correlated

This variable is highly correlated with qt_funcionarios_24meses and should be ignored for analysis

Correlation0.9503

qt_ramos_coligados
Highly correlated

This variable is highly correlated with qt_coligados_matriz and should be ignored for analysis

Correlation0.93462

qt_regioes_coligados
Numeric

Distinct count6
Unique (%)2.3%
Missing (%)71.3%
Missing (n)189
Infinite (%)0.0%
Infinite (n)0
Mean1.4079
Minimum1
Maximum5
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q31
95-th percentile4
Maximum5
Range4
Interquartile range0

Descriptive statistics

Standard deviation0.91181
Coef of variation0.64764
Kurtosis4.7184
Mean1.4079
MAD0.64404
Skewness2.3399
Sum107
Variance0.8314
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%) 
1 60 22.6%
 
2 7 2.6%
 
3 4 1.5%
 
4 4 1.5%
 
5 1 0.4%
 
(Missing) 189 71.3%
 

Minimum 5 values

ValueCountFrequency (%) 
1 60 22.6%
 
2 7 2.6%
 
3 4 1.5%
 
4 4 1.5%
 
5 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
5 1 0.4%
 
4 4 1.5%
 
3 4 1.5%
 
2 7 2.6%
 
1 60 22.6%
 

qt_socios
Highly correlated

This variable is highly correlated with qt_coligados_mei and should be ignored for analysis

Correlation0.98995

qt_socios_coligados
Numeric

Distinct count23
Unique (%)8.7%
Missing (%)71.3%
Missing (n)189
Infinite (%)0.0%
Infinite (n)0
Mean12.763
Minimum1
Maximum138
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median3
Q312
95-th percentile58.5
Maximum138
Range137
Interquartile range11

Descriptive statistics

Standard deviation26.831
Coef of variation2.1022
Kurtosis12.263
Mean12.763
MAD15.086
Skewness3.4887
Sum970
Variance719.92
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 24 9.1%
 
2 13 4.9%
 
4 5 1.9%
 
3 4 1.5%
 
5 4 1.5%
 
14 3 1.1%
 
6 3 1.1%
 
24 2 0.8%
 
28 2 0.8%
 
12 2 0.8%
 
Other values (12) 14 5.3%
 
(Missing) 189 71.3%
 

Minimum 5 values

ValueCountFrequency (%) 
1 24 9.1%
 
2 13 4.9%
 
3 4 1.5%
 
4 5 1.9%
 
5 4 1.5%
 

Maximum 5 values

ValueCountFrequency (%) 
138 1 0.4%
 
128 1 0.4%
 
107 1 0.4%
 
96 1 0.4%
 
46 1 0.4%
 

qt_socios_feminino
Highly correlated

This variable is highly correlated with qt_socios and should be ignored for analysis

Correlation0.99365

qt_socios_masculino
Highly correlated

This variable is highly correlated with qt_socios_feminino and should be ignored for analysis

Correlation0.99163

qt_socios_pep
Highly correlated

This variable is highly correlated with qt_socios_masculino and should be ignored for analysis

Correlation0.99546

qt_socios_pf
Highly correlated

This variable is highly correlated with qt_socios_pep and should be ignored for analysis

Correlation0.99609

qt_socios_pj
Numeric

Distinct count6
Unique (%)2.3%
Missing (%)63.0%
Missing (n)167
Infinite (%)0.0%
Infinite (n)0
Mean0.2551
Minimum0
Maximum5
Zeros (%)31.3%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile2
Maximum5
Range5
Interquartile range0

Descriptive statistics

Standard deviation0.73655
Coef of variation2.8873
Kurtosis19.407
Mean0.2551
MAD0.43211
Skewness3.9797
Sum25
Variance0.5425
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%) 
0 83 31.3%
 
1 9 3.4%
 
2 4 1.5%
 
5 1 0.4%
 
3 1 0.4%
 
(Missing) 167 63.0%
 

Minimum 5 values

ValueCountFrequency (%) 
0 83 31.3%
 
1 9 3.4%
 
2 4 1.5%
 
3 1 0.4%
 
5 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
5 1 0.4%
 
3 1 0.4%
 
2 4 1.5%
 
1 9 3.4%
 
0 83 31.3%
 

qt_socios_pj_ativos
Highly correlated

This variable is highly correlated with qt_socios_pj and should be ignored for analysis

Correlation1

qt_socios_pj_baixados
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_socios_pj_inaptos
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_socios_pj_nulos
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_socios_pj_suspensos
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_socios_st_regular
Highly correlated

This variable is highly correlated with qt_socios_pf and should be ignored for analysis

Correlation0.99836

qt_socios_st_suspensa
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_ufs_coligados
Highly correlated

This variable is highly correlated with qt_regioes_coligados and should be ignored for analysis

Correlation0.90264

setor
Constant

This variable is constant and should be ignored for analysis

Constant valueSERVIÇO

sg_uf
Categorical

Distinct count6
Unique (%)2.3%
Missing (%)0.0%
Missing (n)0
MA
74
PI
52
RN
51
Other values (3)
88
ValueCountFrequency (%) 
MA 74 27.9%
 
PI 52 19.6%
 
RN 51 19.2%
 
AM 43 16.2%
 
AC 23 8.7%
 
RO 22 8.3%
 
Max length2
Mean length2
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

sg_uf_matriz
Categorical

Distinct count6
Unique (%)2.3%
Missing (%)0.0%
Missing (n)0
MA
74
PI
52
RN
51
Other values (3)
88
ValueCountFrequency (%) 
MA 74 27.9%
 
PI 52 19.6%
 
RN 51 19.2%
 
AM 43 16.2%
 
AC 23 8.7%
 
RO 22 8.3%
 
Max length2
Mean length2
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

sum_faturamento_estimado_coligadas
Highly correlated

This variable is highly correlated with media_faturamento_est_coligados_gp and should be ignored for analysis

Correlation0.90166

total
Highly correlated

This variable is highly correlated with qt_funcionarios_grupo and should be ignored for analysis

Correlation0.97431

total_filiais_coligados
Highly correlated

This variable is highly correlated with qt_funcionarios_coligados_gp and should be ignored for analysis

Correlation0.93546

tx_crescimento_12meses
Numeric

Distinct count104
Unique (%)39.2%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean51.831
Minimum-29.633
Maximum12700
Zeros (%)60.8%
Mini histogram

Quantile statistics

Minimum-29.633
5-th percentile-6.5096
Q10
Median0
Q30
95-th percentile29.534
Maximum12700
Range12730
Interquartile range0

Descriptive statistics

Standard deviation780.17
Coef of variation15.052
Kurtosis264.64
Mean51.831
MAD97.851
Skewness16.263
Sum13735
Variance6.0867e+05
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[-2.96326531e+01 -1.45611587e+01 -3.66344006e+00 -7.15307582e-02 1.46627566e-01 6.80991490e+00 2.07987427e+01 8.88235294e+01 1.27000000e+04], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 161 60.8%
 
6.383 2 0.8%
 
-11.377 1 0.4%
 
-2.7523 1 0.4%
 
13.711 1 0.4%
 
75.61 1 0.4%
 
27.139 1 0.4%
 
40.991 1 0.4%
 
-9.8086 1 0.4%
 
-1.4563 1 0.4%
 
Other values (94) 94 35.5%
 

Minimum 5 values

ValueCountFrequency (%) 
-29.633 1 0.4%
 
-25.879 1 0.4%
 
-14.605 1 0.4%
 
-14.518 1 0.4%
 
-13.58 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
12700 1 0.4%
 
246.15 1 0.4%
 
100 1 0.4%
 
77.647 1 0.4%
 
75.61 1 0.4%
 

tx_crescimento_24meses
Highly correlated

This variable is highly correlated with tx_crescimento_12meses and should be ignored for analysis

Correlation0.99596

tx_rotatividade
Numeric

Distinct count106
Unique (%)40.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean6.5663
Minimum0
Maximum101.09
Zeros (%)60.4%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q311.394
95-th percentile28.694
Maximum101.09
Range101.09
Interquartile range11.394

Descriptive statistics

Standard deviation11.828
Coef of variation1.8013
Kurtosis16.077
Mean6.5663
MAD8.6113
Skewness3.0632
Sum1740.1
Variance139.9
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[0.00000000e+00 6.69344043e-02 2.31021759e+01 4.14632035e+01 1.01086957e+02], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 160 60.4%
 
9.037 1 0.4%
 
36.066 1 0.4%
 
40.26 1 0.4%
 
2.5751 1 0.4%
 
4.5326 1 0.4%
 
18.736 1 0.4%
 
34.302 1 0.4%
 
4.8889 1 0.4%
 
9.901 1 0.4%
 
Other values (96) 96 36.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 160 60.4%
 
0.13387 1 0.4%
 
0.14316 1 0.4%
 
0.56117 1 0.4%
 
0.82988 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
101.09 1 0.4%
 
55.352 1 0.4%
 
42.667 1 0.4%
 
40.26 1 0.4%
 
39.184 1 0.4%
 

vl_faturamento_estimado_aux
Numeric

Distinct count248
Unique (%)93.6%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1.0801e+08
Minimum2.004e+07
Maximum2.0116e+09
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2.004e+07
5-th percentile2.2585e+07
Q13.0601e+07
Median5.1001e+07
Q39.9786e+07
95-th percentile3.7865e+08
Maximum2.0116e+09
Range1.9916e+09
Interquartile range6.9186e+07

Descriptive statistics

Standard deviation1.9263e+08
Coef of variation1.7835
Kurtosis45.081
Mean1.0801e+08
MAD9.4175e+07
Skewness5.8515
Sum2.8622e+10
Variance3.7105e+16
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[2.00397240e+07 3.85339680e+07 6.86708350e+07 1.47026665e+08 3.25967480e+08 7.09529855e+08 2.01159680e+09], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
2.4625e+07 3 1.1%
 
2.4882e+07 2 0.8%
 
4.9661e+07 2 0.8%
 
4.5283e+07 2 0.8%
 
2.4419e+07 2 0.8%
 
2.3337e+07 2 0.8%
 
1.174e+08 2 0.8%
 
2.3388e+07 2 0.8%
 
2.7819e+07 2 0.8%
 
2.787e+07 2 0.8%
 
Other values (238) 244 92.1%
 

Minimum 5 values

ValueCountFrequency (%) 
2.004e+07 1 0.4%
 
2.0246e+07 1 0.4%
 
2.0606e+07 2 0.8%
 
2.0709e+07 1 0.4%
 
2.0761e+07 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
2.0116e+09 1 0.4%
 
1.3759e+09 1 0.4%
 
9.3038e+08 1 0.4%
 
9.1462e+08 1 0.4%
 
7.5559e+08 1 0.4%
 

vl_faturamento_estimado_grupo_aux
Highly correlated

This variable is highly correlated with vl_faturamento_estimado_aux and should be ignored for analysis

Correlation0.9811

vl_folha_coligados
Highly correlated

This variable is highly correlated with qt_funcionarios_coligados and should be ignored for analysis

Correlation0.96112

vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with vl_folha_coligados and should be ignored for analysis

Correlation0.94289

vl_frota
Highly correlated

This variable is highly correlated with qt_socios_pep and should be ignored for analysis

Correlation0.91388

vl_idade_maxima_socios_pj
Numeric

Distinct count16
Unique (%)6.0%
Missing (%)94.3%
Missing (n)250
Infinite (%)0.0%
Infinite (n)0
Mean24.037
Minimum0.76112
Maximum52.282
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum0.76112
5-th percentile3.2296
Q19.3388
Median27.8
Q335.418
95-th percentile47.397
Maximum52.282
Range51.521
Interquartile range26.079

Descriptive statistics

Standard deviation16.29
Coef of variation0.67769
Kurtosis-1.2346
Mean24.037
MAD14.082
Skewness0.14165
Sum360.56
Variance265.36
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
27.8 1 0.4%
 
32.942 1 0.4%
 
7.8823 1 0.4%
 
18.338 1 0.4%
 
52.282 1 0.4%
 
4.2875 1 0.4%
 
10.795 1 0.4%
 
37.895 1 0.4%
 
14.283 1 0.4%
 
40.983 1 0.4%
 
Other values (5) 5 1.9%
 
(Missing) 250 94.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0.76112 1 0.4%
 
4.2875 1 0.4%
 
6.2971 1 0.4%
 
7.8823 1 0.4%
 
10.795 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
52.282 1 0.4%
 
45.303 1 0.4%
 
40.983 1 0.4%
 
37.895 1 0.4%
 
32.942 1 0.4%
 

vl_idade_media_socios_pj
Numeric

Distinct count16
Unique (%)6.0%
Missing (%)94.3%
Missing (n)250
Infinite (%)0.0%
Infinite (n)0
Mean17.757
Minimum0.76112
Maximum40.983
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum0.76112
5-th percentile3.2296
Q19.3388
Median15.051
Q327.468
95-th percentile35.354
Maximum40.983
Range40.222
Interquartile range18.129

Descriptive statistics

Standard deviation11.979
Coef of variation0.67464
Kurtosis-0.72067
Mean17.757
MAD9.7264
Skewness0.54425
Sum266.35
Variance143.51
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
32.942 1 0.4%
 
7.8823 1 0.4%
 
18.338 1 0.4%
 
15.051 1 0.4%
 
32.29 1 0.4%
 
4.2875 1 0.4%
 
15.938 1 0.4%
 
10.795 1 0.4%
 
14.283 1 0.4%
 
23.574 1 0.4%
 
Other values (5) 5 1.9%
 
(Missing) 250 94.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0.76112 1 0.4%
 
4.2875 1 0.4%
 
6.2971 1 0.4%
 
7.8823 1 0.4%
 
10.795 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
40.983 1 0.4%
 
32.942 1 0.4%
 
32.29 1 0.4%
 
31.362 1 0.4%
 
23.574 1 0.4%
 

vl_idade_minima_socios_pj
Numeric

Distinct count16
Unique (%)6.0%
Missing (%)94.3%
Missing (n)250
Infinite (%)0.0%
Infinite (n)0
Mean13.76
Minimum0.65982
Maximum40.983
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum0.65982
5-th percentile0.73073
Q13.9576
Median10.795
Q318.843
95-th percentile35.354
Maximum40.983
Range40.323
Interquartile range14.886

Descriptive statistics

Standard deviation12.626
Coef of variation0.91758
Kurtosis0.031974
Mean13.76
MAD9.9599
Skewness1.0058
Sum206.39
Variance159.4
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
32.942 1 0.4%
 
7.8823 1 0.4%
 
12.298 1 0.4%
 
18.338 1 0.4%
 
4.2875 1 0.4%
 
0.65982 1 0.4%
 
10.795 1 0.4%
 
14.283 1 0.4%
 
40.983 1 0.4%
 
31.362 1 0.4%
 
Other values (5) 5 1.9%
 
(Missing) 250 94.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0.65982 1 0.4%
 
0.76112 1 0.4%
 
2.527 1 0.4%
 
3.6277 1 0.4%
 
4.2875 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
40.983 1 0.4%
 
32.942 1 0.4%
 
31.362 1 0.4%
 
19.348 1 0.4%
 
18.338 1 0.4%
 

vl_potenc_cons_oleo_gas
Numeric

Distinct count21
Unique (%)7.9%
Missing (%)91.7%
Missing (n)243
Infinite (%)0.0%
Infinite (n)0
Mean101.91
Minimum1
Maximum430
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile2.05
Q121.25
Median45
Q3163.5
95-th percentile368.45
Maximum430
Range429
Interquartile range142.25

Descriptive statistics

Standard deviation125.44
Coef of variation1.2309
Kurtosis1.3393
Mean101.91
MAD100.51
Skewness1.4858
Sum2242
Variance15736
Memory size14.1 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
32 2 0.8%
 
45 2 0.8%
 
22 1 0.4%
 
7 1 0.4%
 
216 1 0.4%
 
374 1 0.4%
 
226 1 0.4%
 
3 1 0.4%
 
138 1 0.4%
 
172 1 0.4%
 
Other values (10) 10 3.8%
 
(Missing) 243 91.7%
 

Minimum 5 values

ValueCountFrequency (%) 
1 1 0.4%
 
2 1 0.4%
 
3 1 0.4%
 
7 1 0.4%
 
8 1 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
430 1 0.4%
 
374 1 0.4%
 
263 1 0.4%
 
226 1 0.4%
 
216 1 0.4%
 

vl_total_tancagem
Categorical

Distinct count5
Unique (%)1.9%
Missing (%)96.2%
Missing (n)255
15
 
7
45
 
1
40
 
1
(Missing)
255
ValueCountFrequency (%) 
15 7 2.6%
 
45 1 0.4%
 
40 1 0.4%
 
30 1 0.4%
 
(Missing) 255 96.2%
 
Max length4
Mean length3.0377
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

vl_total_tancagem_grupo
Highly correlated

This variable is highly correlated with vl_idade_minima_socios_pj and should be ignored for analysis

Correlation0.94442

vl_total_veiculos_antt
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

vl_total_veiculos_antt_grupo
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

vl_total_veiculos_leves
Highly correlated

This variable is highly correlated with qt_socios_pep and should be ignored for analysis

Correlation0.93282

vl_total_veiculos_leves_grupo
Highly correlated

This variable is highly correlated with vl_total_veiculos_leves and should be ignored for analysis

Correlation0.99727

vl_total_veiculos_pesados
Highly correlated

This variable is highly correlated with vl_potenc_cons_oleo_gas and should be ignored for analysis

Correlation0.9929

vl_total_veiculos_pesados_grupo
Highly correlated

This variable is highly correlated with vl_total_veiculos_pesados and should be ignored for analysis

Correlation0.99781

Correlations

Missing values

Sample

First rows

coligada_mais_antiga_ativacoligada_mais_antiga_baixadacoligada_mais_nova_ativacoligada_mais_nova_baixadade_faixa_faturamento_estimadode_faixa_faturamento_estimado_grupode_indicador_telefonede_natureza_juridicade_nivel_atividadede_ramode_saude_rescenciade_saude_tributariadt_situacaoempsetorcensitariofaixarendapopulacaofaturamento_est_coligadosfaturamento_est_coligados_gpfl_anttfl_emailfl_eppfl_ltdafl_matrizfl_mefl_meifl_optante_simeifl_optante_simplesfl_passivel_issfl_rmfl_safl_simples_irregularfl_spafl_st_especialfl_telefonefl_veiculograu_instrucao_macro_analfabetograu_instrucao_macro_desconhecidograu_instrucao_macro_escolaridade_fundamentalgrau_instrucao_macro_escolaridade_mediagrau_instrucao_macro_escolaridade_superiorididade_acima_de_58idade_ate_18idade_de_19_a_23idade_de_24_a_28idade_de_29_a_33idade_de_34_a_38idade_de_39_a_43idade_de_44_a_48idade_de_49_a_53idade_de_54_a_58idade_emp_catidade_empresa_anosidade_maxima_coligadasidade_maxima_sociosidade_media_coligadasidade_media_coligadas_ativasidade_media_coligadas_baixadasidade_media_sociosidade_minima_coligadasidade_minima_sociosmax_faturamento_est_coligadosmax_faturamento_est_coligados_gpmax_filiais_coligadosmax_funcionarios_coligados_gpmax_meses_servicosmax_meses_servicos_allmax_vl_folha_coligadosmax_vl_folha_coligados_gpmedia_faturamento_est_coligadosmedia_faturamento_est_coligados_gpmedia_filiais_coligadosmedia_funcionarios_coligados_gpmedia_meses_servicosmedia_meses_servicos_allmedia_vl_folha_coligadosmedia_vl_folha_coligados_gpmeses_ultima_contratacacomin_faturamento_est_coligadosmin_faturamento_est_coligados_gpmin_filiais_coligadosmin_funcionarios_coligados_gpmin_meses_servicosmin_meses_servicos_allmin_vl_folha_coligadosmin_vl_folha_coligados_gpnatureza_juridica_macronm_divisaonm_meso_regiaonm_micro_regiaonm_segmentonu_meses_rescenciapercent_func_genero_fempercent_func_genero_mascqt_admitidosqt_admitidos_12mesesqt_alteracao_socio_180dqt_alteracao_socio_365dqt_alteracao_socio_90dqt_alteracao_socio_totalqt_artqt_coligadasqt_coligadosqt_coligados_agropecuariaqt_coligados_atividade_altoqt_coligados_atividade_baixoqt_coligados_atividade_inativoqt_coligados_atividade_medioqt_coligados_atividade_mt_baixoqt_coligados_ativoqt_coligados_baixadaqt_coligados_ccivilqt_coligados_centroqt_coligados_comercioqt_coligados_eppqt_coligados_exteriorqt_coligados_inaptaqt_coligados_industriaqt_coligados_ltdaqt_coligados_matrizqt_coligados_meqt_coligados_meiqt_coligados_nordesteqt_coligados_norteqt_coligados_nulaqt_coligados_saqt_coligados_serviçoqt_coligados_sudesteqt_coligados_sulqt_coligados_suspensaqt_desligadosqt_desligados_12mesesqt_ex_funcionariosqt_filiaisqt_funcionariosqt_funcionarios_12mesesqt_funcionarios_24mesesqt_funcionarios_coligadosqt_funcionarios_coligados_gpqt_funcionarios_grupoqt_ramos_coligadosqt_regioes_coligadosqt_sociosqt_socios_coligadosqt_socios_femininoqt_socios_masculinoqt_socios_pepqt_socios_pfqt_socios_pjqt_socios_pj_ativosqt_socios_pj_baixadosqt_socios_pj_inaptosqt_socios_pj_nulosqt_socios_pj_suspensosqt_socios_st_regularqt_socios_st_suspensaqt_ufs_coligadossetorsg_ufsg_uf_matrizsum_faturamento_estimado_coligadastotaltotal_filiais_coligadostx_crescimento_12mesestx_crescimento_24mesestx_rotatividadevl_faturamento_estimado_auxvl_faturamento_estimado_grupo_auxvl_folha_coligadosvl_folha_coligados_gpvl_frotavl_idade_maxima_socios_pjvl_idade_media_socios_pjvl_idade_minima_socios_pjvl_potenc_cons_oleo_gasvl_total_tancagemvl_total_tancagem_grupovl_total_veiculos_anttvl_total_veiculos_antt_grupovl_total_veiculos_levesvl_total_veiculos_leves_grupovl_total_veiculos_pesadosvl_total_veiculos_pesados_grupo
0NaNNaNNaNNaNDE R$ 100.000.000,01 A R$ 300.000.000,00DE R$ 100.000.000,01 A R$ 300.000.000,00NaNMUNICIPIOALTAADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIALACIMA DE 1 ANOVERDE2005-11-03644.27NaNNaNFalseTrueFalseFalseTrueFalseFalseFalseFalseTrueNAOFalseFalseFalseFalseFalseTrueNaNNaN117.0106.0522.0bb61c09449a1c1f8b78955d8b7a7f73599e78358993fe24b56a3e11f7d6a0bce45.0NaNNaN44.0107.0162.0161.0113.069.044.0> 2021.813699NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN259.166667259.166667NaNNaNNaNNaNNaNNaN144.663535133.286943NaNNaN40.500000NaNNaNNaNNaN40.500000-2.466667NaNNaNOUTROSADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIALOESTE MARANHENSEPINDAREADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL26.063.3636.64845.00.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN100.00.0100.02745.0745.0745.0NaNNaN745.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNSERVIÇOMAMANaN745.0NaN0.0000000.0000000.000000141308380.0144348380.0NaNNaN275282.0NaNNaNNaNNaNNaNNaNNaNNaN5.05.02.02.0
1NaNNaNNaNNaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 10.000.000,01 A R$ 30.000.000,00BOASOCIEDADE SIMPLES LIMITADAALTASERVICOS DE EDUCACAOACIMA DE 1 ANOVERDE2005-09-24688.31NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseTrueNAOFalseFalseFalseFalseTrueTrueNaNNaN19.09.091.016843c9ffb920170477118933798510d8d5f00f5c56c1221773356355bded3212.0NaN1.010.027.030.020.015.011.03.015 a 2016.389041NaN70.0NaNNaNNaN70.0NaN70.0NaNNaNNaNNaN149.033333149.033333NaNNaNNaNNaNNaNNaN65.94201742.166782NaNNaN4.866667NaNNaNNaNNaN4.8666670.000000NaNNaNENTIDADES EMPRESARIAISEDUCACAONORTE PIAUIENSEBAIXO PARNAIBA PIAUIENSEEDUCACAO23.047.9052.10291.021.0NaNNaNNaNNaN1.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN172.07.0172.00119.0104.0113.0NaNNaN119.0NaNNaN2.0NaN1.0NaNNaN2.00.0NaNNaNNaNNaNNaN1.0NaNNaNSERVIÇOPIPINaN119.0NaN14.4230775.3097356.25000027818640.027818640.0NaNNaN60101.0NaNNaNNaNNaNNaNNaNNaNNaN1.01.01.01.0
2NaNNaNNaNNaNDE R$ 30.000.000,01 A R$ 100.000.000,00DE R$ 30.000.000,01 A R$ 100.000.000,00BOAORGAO PUBLICO DO PODER EXECUTIVO ESTADUAL OU DO DISTRITO FEDERALALTAADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIALACIMA DE 1 ANOAZUL1998-07-281881.35NaNNaNFalseTrueFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseTrueFalseNaNNaN56.026.088.01b8d092daff12bed8b3c2ab93bf5df2921865a68aca185f51e31e7105abb0c4873.0NaN1.07.010.011.012.09.014.033.0> 2040.380822NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN557.8666675014.966667NaNNaNNaNNaNNaNNaN284.854706216.077090NaNNaN24.200000NaNNaNNaNNaN24.2000000.633333NaNNaNADMINISTRACAO PUBLICAADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIALCENTRO AMAZONENSEMANAUSADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL23.056.4743.53291.00.0NaNNaNNaNNaN32.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN121.00.0121.00170.0170.0177.0NaNNaN170.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNSERVIÇOAMAMNaN170.0NaN0.000000-3.9548020.00000092728800.092728800.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
3NaNNaNNaNNaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 10.000.000,01 A R$ 30.000.000,00BOAMUNICIPIOALTAADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIALACIMA DE 1 ANOAZUL2005-10-14353.66NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseFalseTrueNaNNaN35.053.063.03aafa3a1f12f483740a52956af100223333d0e3c79bf2ce341896dd554e7229314.0NaNNaNNaN8.018.029.022.031.029.0> 2043.854795NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN506.9666675014.966667NaNNaNNaNNaNNaNNaN189.020309316.503220NaNNaN31.333333NaNNaNNaNNaN31.3333338.733333NaNNaNOUTROSADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIALCENTRO NORTE PIAUIENSEVALENCA DO PIAUIADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL23.073.5126.49176.00.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN25.00.025.00151.0151.0151.0NaNNaN151.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNSERVIÇOPIPINaN151.0NaN0.0000000.0000000.00000024418584.024418584.0NaNNaN87223.0NaNNaNNaNNaNNaNNaNNaNNaN1.01.02.02.0
4NaNNaNNaNNaNDE R$ 30.000.000,01 A R$ 100.000.000,00DE R$ 30.000.000,01 A R$ 100.000.000,00NaNMUNICIPIOALTAADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIALACIMA DE 1 ANOAZUL2005-06-11NaNNaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseTrueNAOFalseFalseFalseFalseFalseTrueNaNNaNNaN147.082.0c60431fbca90067f105570e1e8a684bcd7048205bbf6c40d71c3d558626f234424.0NaNNaN6.010.012.045.050.048.034.0> 2043.865753NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN556.8333335014.966667NaNNaNNaNNaNNaNNaN238.418341146.443381NaNNaN23.200000NaNNaNNaNNaN34.033333-0.066667NaNNaNOUTROSADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIALAGRESTE POTIGUARBAIXA VERDEADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL23.072.9327.07836.00.0NaNNaNNaNNaN4.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN607.00.0606.01229.0229.0418.0NaNNaN229.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNSERVIÇORNRNNaN229.0NaN0.000000-45.2153110.00000038585484.038585484.0NaNNaN23412.0NaNNaNNaNNaNNaNNaNNaNNaN0.00.00.00.0
5634.266667NaN145.700000NaNDE R$ 30.000.000,01 A R$ 100.000.000,00DE R$ 30.000.000,01 A R$ 100.000.000,00BOAASSOCIACAO PRIVADAALTASERVICOS DE EDUCACAOACIMA DE 1 ANOVERDE2005-09-241016.4810770780.030684070.0FalseTrueFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseTrueTrueNaNNaN11.015.0144.05de08033561948a226f8ba8f8668a4ff4123be8ea7114dce5d7c0d74f61837bf13.0NaN2.09.029.028.026.035.018.010.0> 2047.087671634.26666740.0389.983333389.983333NaN38.0145.70000036.010560780.025483750.015.0309.0397.633333481.3000004224312.010468051.05385390.015342035.010.0159.099.53019678.1542364224312.05491605.520.433333210000.05200320.05.09.020.4333330.2000004224312.0515160.0ENTIDADES SEM FINS LUCRATIVOSEDUCACAOLESTE POTIGUARNATALEDUCACAO23.045.2954.71424.00.0NaNNaNNaNNaN1.02.02.00.00.00.00.00.00.02.00.00.00.00.00.00.00.00.00.02.00.00.02.00.00.00.02.00.00.00.0254.00.0254.01170.0170.0206.0112.0318.0393.02.01.03.02.0NaN2.0NaN3.00.0NaNNaNNaNNaNNaN2.0NaN1.0SERVIÇORNRN10770780.0170.020.00.000000-17.4757280.00000042500700.093862150.04224312.010983211.0141655.0NaNNaNNaNNaNNaNNaNNaNNaN2.04.01.01.0
6NaNNaNNaNNaNDE R$ 100.000.000,01 A R$ 300.000.000,00DE R$ 100.000.000,01 A R$ 300.000.000,00BOAORGAO PUBLICO DO PODER EXECUTIVO ESTADUAL OU DO DISTRITO FEDERALALTAADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIALACIMA DE 1 ANOVERDE2003-02-061811.66NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseFalseFalseNaNNaN53.0297.0268.0194e619cb6417f92f75653406cf04106debc5035f13a8850b00428fd34d91d72216.0NaN5.015.043.042.029.051.078.0139.015 a 2015.734247NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN191.600000467.233333NaNNaNNaNNaNNaNNaN138.385891126.687314NaNNaN24.200000NaNNaNNaNNaN24.2000002.566667NaNNaNADMINISTRACAO PUBLICAADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIALNORTE MARANHENSEAGLOMERACAO URBANA DE SAO LUISADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL23.049.3550.65896.00.0NaNNaNNaNNaN3.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN277.00.0278.00619.0619.0690.0NaNNaN618.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNSERVIÇOMAMANaN618.0NaN0.000000-10.2898550.000000195554740.0195554740.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
7NaNNaNNaNNaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 10.000.000,01 A R$ 30.000.000,00BOAEMPRESARIO INDIVIDUALALTASERVICOS DE ALOJAMENTO/ALIMENTACAOACIMA DE 1 ANOVERDE2003-03-15857.89NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseFalseTrueNaNNaN18.0143.07.0cc734f72fdd8753ba2e7638f3d09e0597fd859735904dafab03cec6b347b331d3.0NaN10.026.034.038.028.018.07.04.0> 2026.520548NaN63.0NaNNaNNaN63.0NaN63.0NaNNaNNaNNaN274.300000274.300000NaNNaNNaNNaNNaNNaN44.56627029.254984NaNNaN2.433333NaNNaNNaNNaN2.433333-0.600000NaNNaNOUTROSALIMENTACAOCENTRO AMAZONENSEMANAUSALOJAMENTO E ALIMENTACAO23.022.6277.38428.010.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN260.02.0260.01168.0160.0186.0NaNNaN168.0NaNNaN1.0NaNNaN1.0NaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNSERVIÇOAMAMNaN168.0NaN5.000000-9.6774191.21951226994384.027924384.0NaNNaN382387.0NaNNaNNaNNaNNaNNaNNaNNaN3.03.05.05.0
861.333333NaN17.933333NaNDE R$ 30.000.000,01 A R$ 100.000.000,00DE R$ 30.000.000,01 A R$ 100.000.000,00BOASOCIEDADE EMPRESARIA LIMITADAALTASERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOSACIMA DE 1 ANOVERDE2010-05-20NaN19171824.019381824.0FalseTrueFalseFalseTrueFalseFalseFalseFalseTrueNAOFalseFalseFalseFalseTrueTrue2.0NaN17.098.064.07e46107cb32e64f7f90ec16372d29f205f0d9781140308267f8c5d07b65a22fe6.05.010.036.040.043.019.011.07.04.05 a 108.44657561.33333341.032.54444432.544444NaN40.017.93333339.018751824.018961824.01.0118.083.73333383.7333337500729.57500729.56390608.06460608.01.0118.030.02985318.9084077500729.57500729.52.033333210000.0210000.01.0118.02.033333-0.6000007500729.57500729.5ENTIDADES EMPRESARIAISSERVICOS DE ARQUITETURA E ENGENHARIA TESTES E ANALISES TECNICASVALE DO ACRERIO BRANCOATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS23.028.1871.82452.058.0NaNNaNNaNNaN6.03.03.00.00.00.00.00.00.03.00.03.00.00.00.00.00.00.00.03.00.00.00.03.00.00.00.00.00.00.0270.049.0270.00182.0179.0131.0118.0118.0181.01.01.02.05.0NaN2.0NaN2.00.0NaNNaNNaNNaNNaN2.0NaN1.0SERVIÇOACAC19171824.0181.03.01.67597838.93129827.60563435185428.035185428.07500729.57500729.5559626.0NaNNaNNaNNaNNaNNaNNaNNaN11.011.01.01.0
9116.133333NaN116.133333NaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 10.000.000,01 A R$ 30.000.000,00BOASOCIEDADE EMPRESARIA LIMITADAALTASERVICOS ADMINISTRATIVOSACIMA DE 1 ANOVERDE2007-10-182346.0923182200.023182200.0FalseTrueFalseFalseTrueFalseFalseFalseFalseTrueNAOFalseFalseFalseFalseTrueTrueNaNNaN15.0117.016.02206453fbc92af65e47ce6ee2be27fa90ac427845ea0a539a1ab78df1388e7d21.0NaN23.041.021.026.016.011.07.02.010 a 1511.035616116.13333364.0116.133333116.133333NaN49.0116.13333334.023182200.023182200.0NaN161.0113.533333113.5333339272880.09272880.023182200.023182200.0NaN161.040.44977521.5827709272880.09272880.02.93333323182200.023182200.0NaN161.02.933333-0.5000009272880.09272880.0ENTIDADES EMPRESARIAISSERVICOS PARA EDIFICIOS E ATIVIDADES PAISAGISTICASNaNNaNATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARES23.061.4938.51978.029.0NaNNaNNaNNaNNaN1.01.00.00.00.00.00.00.01.00.00.00.00.00.00.00.00.00.01.00.00.00.01.00.00.01.00.00.00.0830.050.0830.00148.0167.0220.0161.0161.0148.01.01.02.01.01.01.0NaN2.00.0NaNNaNNaNNaNNaN2.0NaN1.0SERVIÇORORO23182200.0148.0NaN-11.377246-32.72727331.54574122357944.022357944.09272880.09272880.0248083.0NaNNaNNaNNaNNaNNaNNaNNaN3.03.00.00.0

Last rows

coligada_mais_antiga_ativacoligada_mais_antiga_baixadacoligada_mais_nova_ativacoligada_mais_nova_baixadade_faixa_faturamento_estimadode_faixa_faturamento_estimado_grupode_indicador_telefonede_natureza_juridicade_nivel_atividadede_ramode_saude_rescenciade_saude_tributariadt_situacaoempsetorcensitariofaixarendapopulacaofaturamento_est_coligadosfaturamento_est_coligados_gpfl_anttfl_emailfl_eppfl_ltdafl_matrizfl_mefl_meifl_optante_simeifl_optante_simplesfl_passivel_issfl_rmfl_safl_simples_irregularfl_spafl_st_especialfl_telefonefl_veiculograu_instrucao_macro_analfabetograu_instrucao_macro_desconhecidograu_instrucao_macro_escolaridade_fundamentalgrau_instrucao_macro_escolaridade_mediagrau_instrucao_macro_escolaridade_superiorididade_acima_de_58idade_ate_18idade_de_19_a_23idade_de_24_a_28idade_de_29_a_33idade_de_34_a_38idade_de_39_a_43idade_de_44_a_48idade_de_49_a_53idade_de_54_a_58idade_emp_catidade_empresa_anosidade_maxima_coligadasidade_maxima_sociosidade_media_coligadasidade_media_coligadas_ativasidade_media_coligadas_baixadasidade_media_sociosidade_minima_coligadasidade_minima_sociosmax_faturamento_est_coligadosmax_faturamento_est_coligados_gpmax_filiais_coligadosmax_funcionarios_coligados_gpmax_meses_servicosmax_meses_servicos_allmax_vl_folha_coligadosmax_vl_folha_coligados_gpmedia_faturamento_est_coligadosmedia_faturamento_est_coligados_gpmedia_filiais_coligadosmedia_funcionarios_coligados_gpmedia_meses_servicosmedia_meses_servicos_allmedia_vl_folha_coligadosmedia_vl_folha_coligados_gpmeses_ultima_contratacacomin_faturamento_est_coligadosmin_faturamento_est_coligados_gpmin_filiais_coligadosmin_funcionarios_coligados_gpmin_meses_servicosmin_meses_servicos_allmin_vl_folha_coligadosmin_vl_folha_coligados_gpnatureza_juridica_macronm_divisaonm_meso_regiaonm_micro_regiaonm_segmentonu_meses_rescenciapercent_func_genero_fempercent_func_genero_mascqt_admitidosqt_admitidos_12mesesqt_alteracao_socio_180dqt_alteracao_socio_365dqt_alteracao_socio_90dqt_alteracao_socio_totalqt_artqt_coligadasqt_coligadosqt_coligados_agropecuariaqt_coligados_atividade_altoqt_coligados_atividade_baixoqt_coligados_atividade_inativoqt_coligados_atividade_medioqt_coligados_atividade_mt_baixoqt_coligados_ativoqt_coligados_baixadaqt_coligados_ccivilqt_coligados_centroqt_coligados_comercioqt_coligados_eppqt_coligados_exteriorqt_coligados_inaptaqt_coligados_industriaqt_coligados_ltdaqt_coligados_matrizqt_coligados_meqt_coligados_meiqt_coligados_nordesteqt_coligados_norteqt_coligados_nulaqt_coligados_saqt_coligados_serviçoqt_coligados_sudesteqt_coligados_sulqt_coligados_suspensaqt_desligadosqt_desligados_12mesesqt_ex_funcionariosqt_filiaisqt_funcionariosqt_funcionarios_12mesesqt_funcionarios_24mesesqt_funcionarios_coligadosqt_funcionarios_coligados_gpqt_funcionarios_grupoqt_ramos_coligadosqt_regioes_coligadosqt_sociosqt_socios_coligadosqt_socios_femininoqt_socios_masculinoqt_socios_pepqt_socios_pfqt_socios_pjqt_socios_pj_ativosqt_socios_pj_baixadosqt_socios_pj_inaptosqt_socios_pj_nulosqt_socios_pj_suspensosqt_socios_st_regularqt_socios_st_suspensaqt_ufs_coligadossetorsg_ufsg_uf_matrizsum_faturamento_estimado_coligadastotaltotal_filiais_coligadostx_crescimento_12mesestx_crescimento_24mesestx_rotatividadevl_faturamento_estimado_auxvl_faturamento_estimado_grupo_auxvl_folha_coligadosvl_folha_coligados_gpvl_frotavl_idade_maxima_socios_pjvl_idade_media_socios_pjvl_idade_minima_socios_pjvl_potenc_cons_oleo_gasvl_total_tancagemvl_total_tancagem_grupovl_total_veiculos_anttvl_total_veiculos_antt_grupovl_total_veiculos_levesvl_total_veiculos_leves_grupovl_total_veiculos_pesadosvl_total_veiculos_pesados_grupo
255NaNNaNNaNNaNDE R$ 100.000.000,01 A R$ 300.000.000,00DE R$ 100.000.000,01 A R$ 300.000.000,00NaNORGAO PUBLICO DO PODER EXECUTIVO ESTADUAL OU DO DISTRITO FEDERALALTAADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIALACIMA DE 1 ANOVERDE2005-11-033419.68NaNNaNFalseTrueFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseTrueTrueNaNNaN63.0271.0229.01ec76d8ef1d7c6bb73ef86a43d713725b1b610240bdf4a729cdd9ba076ad47a8210.01.08.011.040.028.030.048.071.0116.015 a 2019.843836NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN490.433333490.433333NaNNaNNaNNaNNaNNaN180.18144297.031514NaNNaN3.466667NaNNaNNaNNaN3.4666671.800000NaNNaNADMINISTRACAO PUBLICAADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIALNORTE MARANHENSEAGLOMERACAO URBANA DE SAO LUISADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL22.055.4244.581484.06.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN920.08.0920.00564.0566.0615.0NaNNaN563.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNSERVIÇOMAMANaN563.0NaN-0.353357-8.2926831.415929169642190.0169642190.0NaNNaN10151299.0NaNNaNNaNNaNNaNNaNNaNNaN101.0101.00.00.0
256516.933333NaN39.733333NaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 10.000.000,01 A R$ 30.000.000,00BOASOCIEDADE EMPRESARIA LIMITADAALTASERVICOS DE SAUDEACIMA DE 1 ANOVERDE2005-11-032348.343.915216e+063.915216e+06FalseTrueFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseTrueTrueNaNNaN12.091.042.0a3d4217a7c01f6cabd26d86cb283923c682a18d516f015e6f8b4796da8fef659NaNNaN13.023.032.033.018.016.06.04.015 a 2019.761644516.93333344.0203.111111203.111111NaN41.539.73333339.02.843683e+062.843683e+06NaN13.0121.600000121.600000947894.4947894.41.305072e+061.305072e+06NaN7.00000052.99954340.7570374.533408e+054.533408e+053.933333329702.4329702.4NaN4.03.9333330.466667164851.2164851.2ENTIDADES EMPRESARIAISATIVIDADES DE ATENCAO A SAUDE HUMANACENTRO NORTE PIAUIENSETERESINASAUDE HUMANA E SERVICOS SOCIAIS23.069.6630.34270.014.0NaNNaNNaNNaNNaN3.03.00.00.00.00.00.00.03.00.00.00.02.00.00.00.00.00.03.00.00.03.00.00.00.01.00.00.00.0124.09.0124.03146.0141.0166.021.021.0145.03.01.02.04.01.01.0NaN2.00.0NaNNaNNaNNaNNaN2.0NaN1.0SERVIÇOPIPI3.915216e+06145.0NaN3.546099-12.0481936.27177724727680.028697680.01.360022e+061.360022e+06182413.0NaNNaNNaNNaNNaNNaNNaNNaN4.04.02.02.0
25725.566667NaN25.566667NaNDE R$ 30.000.000,01 A R$ 100.000.000,00DE R$ 30.000.000,01 A R$ 100.000.000,00BOAEMPRESA INDIVIDUAL DE RESPONSABILIDADE LIMITADA DE NATUREZA EMPRESARIAALTASERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOSACIMA DE 1 ANOVERDE2005-10-143021.532.100000e+052.100000e+05FalseFalseFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseFalseTrue1.0NaN73.0122.05.0feb9c97a3f694c22a919d9544c433da92d34d5717b43d54d88f543aa462958ae2.0NaN19.028.046.035.027.019.016.09.015 a 2016.76986325.566667NaN25.56666725.566667NaNNaN25.566667NaN2.100000e+052.100000e+05NaNNaN92.23333392.233333NaNNaN2.100000e+052.100000e+05NaNNaN18.9296128.896976NaNNaN3.700000210000.0210000.0NaNNaN3.700000-0.533333NaNNaNOUTROSSERVICOS DE ARQUITETURA E ENGENHARIA TESTES E ANALISES TECNICASNORTE MARANHENSEAGLOMERACAO URBANA DE SAO LUISATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS23.04.9895.02983.0230.0NaNNaNNaNNaN5.01.01.00.00.00.00.00.00.01.00.00.00.00.00.00.00.01.00.01.00.00.01.00.00.00.00.00.00.00.0777.0186.0774.00206.0152.0119.0NaNNaN201.01.01.01.01.0NaNNaNNaN1.00.0NaNNaNNaNNaNNaNNaNNaN1.0SERVIÇOMAMA2.100000e+05201.0NaN35.52631673.109244101.08695731321728.031321728.0NaNNaN85833.0NaNNaNNaNNaNNaNNaNNaNNaN4.04.00.00.0
258NaNNaNNaNNaNDE R$ 30.000.000,01 A R$ 100.000.000,00DE R$ 30.000.000,01 A R$ 100.000.000,00BOAORGAO PUBLICO DO PODER EXECUTIVO MUNICIPALMEDIAADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIALACIMA DE 1 ANOAZUL2000-12-271359.01NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseFalseFalseNaNNaN18.0305.055.0efd51c8f53a5931f1778398c485a861169c99a40072d8f8c8005b90c2ccb7ee6206.0NaN2.02.010.013.011.09.051.074.015 a 2017.846575NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN607.633333607.633333NaNNaNNaNNaNNaNNaN353.954938281.495431NaNNaN37.266667NaNNaNNaNNaN37.266667-0.266667NaNNaNADMINISTRACAO PUBLICAADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIALCENTRO NORTE PIAUIENSETERESINAADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL23.014.0285.98572.00.0NaNNaNNaNNaN6.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN194.00.0194.00378.0378.0379.0NaNNaN378.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNSERVIÇOPIPINaN378.0NaN0.000000-0.2638520.00000059810076.059810076.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
259NaNNaNNaNNaNDE R$ 30.000.000,01 A R$ 100.000.000,00DE R$ 30.000.000,01 A R$ 100.000.000,00NaNMUNICIPIOALTAADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIALACIMA DE 1 ANOAZUL2005-04-02372.23NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseTrueNAOFalseFalseFalseFalseFalseTrueNaNNaN15.0305.033.0120ecac76e64ace3880969e7a6c7a20ff116b94a411fd0b53216978136a7d85b23.0NaN2.05.035.044.092.060.061.031.0> 2043.539726NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN501.0666675014.966667NaNNaNNaNNaNNaNNaN181.59282392.680587NaNNaN2.500000NaNNaNNaNNaN2.500000-5.100000NaNNaNOUTROSADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIALLESTE POTIGUARLITORAL NORDESTEADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL23.052.1247.88977.09.0NaNNaNNaNNaN18.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN624.00.0624.01353.0344.0564.0NaNNaN353.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNSERVIÇORNRNNaN353.0NaN2.616279-37.4113480.00000063313164.063313164.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.00.01.01.0
260206.900000NaN27.166667NaNDE R$ 10.000.000,01 A R$ 30.000.000,00DE R$ 10.000.000,01 A R$ 30.000.000,00BOACOOPERATIVAALTASERVICOS FINANCEIROSACIMA DE 1 ANOVERDE2005-11-031365.701.462024e+071.779363e+07FalseTrueFalseFalseTrueFalseFalseFalseFalseTrueNAOFalseFalseFalseFalseTrueFalseNaNNaNNaN16.072.0b6966d868fb7976f993aca02fb667c9ae8f5ebf4d2e033182d67d119a6a3db135.02.06.024.018.021.02.06.02.02.015 a 2018.980822206.90000052.0126.222222126.222222NaN52.027.16666752.01.045775e+071.045775e+073.057.0176.300000218.2000004183099.24183099.24.873414e+065.931209e+063.042.33333351.35393343.7035092.088115e+062.617013e+062.266667700617.63461875.23.026.02.266667-0.300000350308.81730937.6ENTIDADES EMPRESARIAISATIVIDADES DE SERVICOS FINANCEIROSNaNNaNATIVIDADES FINANCEIRAS DE SEGUROS E SERVICOS RELACIONADOS23.055.6844.32152.012.0NaNNaNNaNNaNNaN3.03.00.00.00.00.00.00.03.00.00.00.00.00.00.00.00.00.03.00.00.00.01.00.00.03.02.00.00.063.09.063.0089.086.073.0106.0127.088.03.02.02.03.0NaN1.0NaN2.00.0NaNNaNNaNNaNNaN1.0NaN2.0SERVIÇORORO1.462024e+0788.03.03.48837221.91780810.28571423903424.023903424.06.264346e+067.851038e+06NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
261158.600000NaN20.600000NaNDE R$ 30.000.000,01 A R$ 100.000.000,00DE R$ 30.000.000,01 A R$ 100.000.000,00BOASOCIEDADE EMPRESARIA LIMITADAALTASERVICOS DE SAUDEACIMA DE 1 ANOVERDE2002-11-162484.074.200000e+054.200000e+05FalseFalseFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseFalseTrue1.0NaN4.0119.073.04a87a82771996c18afc68a17d139bd318d08fa3e5dcf9f8aea4ed92b8c76b5d1NaN6.020.046.044.034.023.012.08.04.0> 2022.493151158.60000051.089.60000089.600000NaN36.020.60000027.02.100000e+052.100000e+05NaNNaN271.800000271.800000NaNNaN2.100000e+052.100000e+05NaNNaN63.10049349.762882NaNNaN2.533333210000.0210000.0NaNNaN2.5333330.600000NaNNaNENTIDADES EMPRESARIAISATIVIDADES DE ATENCAO A SAUDE HUMANACENTRO NORTE PIAUIENSETERESINASAUDE HUMANA E SERVICOS SOCIAIS25.068.0231.98414.027.0NaNNaNNaNNaN4.02.02.00.00.00.00.00.00.02.00.00.00.01.00.00.00.00.00.02.00.00.02.00.00.00.01.00.00.00.0211.030.0210.03203.0206.0243.0NaNNaN224.02.01.04.05.01.02.0NaN4.00.0NaNNaNNaNNaNNaN3.0NaN1.0SERVIÇOPIPI4.200000e+05197.0NaN-1.456311-16.46090514.66992730136860.033145394.0NaNNaN447145.0NaNNaNNaNNaNNaNNaNNaNNaN7.07.00.00.0
26256.200000NaN56.200000NaNDE R$ 30.000.000,01 A R$ 100.000.000,00DE R$ 30.000.000,01 A R$ 100.000.000,00BOASOCIEDADE EMPRESARIA LIMITADAALTASERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOSACIMA DE 1 ANOVERDE2006-02-01NaN9.300000e+059.300000e+05FalseTrueFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseTrueFalseNaNNaN150.0127.02.0f3b468c4066fac0d2de28bdafa87ec8b9d103a085cf7de5891b7bafbd7fe7cfc34.0NaN6.021.026.045.041.043.044.019.010 a 1512.74520556.20000049.056.20000056.200000NaN41.056.20000033.09.300000e+059.300000e+05NaNNaN5099.0666675099.066667NaNNaN9.300000e+059.300000e+05NaNNaN173.80967761.097177NaNNaN20.733333930000.0930000.0NaNNaN24.700000-0.566667NaNNaNENTIDADES EMPRESARIAISSERVICOS DE ARQUITETURA E ENGENHARIA TESTES E ANALISES TECNICASCENTRO AMAZONENSEMANAUSATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS23.063.4436.56981.00.0NaNNaNNaNNaNNaN1.01.00.00.00.00.00.00.01.00.00.00.00.00.00.00.00.00.01.00.00.00.01.00.00.01.00.00.00.0702.08.0702.00279.0287.0296.0NaNNaN279.01.01.02.01.0NaN2.0NaN2.00.0NaNNaNNaNNaNNaN2.0NaN1.0SERVIÇOAMAM9.300000e+05279.0NaN-2.787456-5.7432432.82685540955220.040955220.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
263321.633333NaN10.366667NaNDE R$ 30.000.000,01 A R$ 100.000.000,00DE R$ 30.000.000,01 A R$ 100.000.000,00BOACOOPERATIVAALTASEGUROS, PLANOS DE PREVIDENCIA E PLANOS DE SAUDEACIMA DE 1 ANOAZUL2003-11-082281.442.275368e+072.720860e+07FalseTrueFalseFalseTrueFalseFalseFalseFalseTrueNAOFalseFalseFalseFalseTrueTrueNaNNaN6.045.069.098448fefe3e358578fa643b63fcdcf4a3f2dcb496863f8eb7cc85a0f4036e5113.07.09.022.022.021.012.012.06.06.0> 2026.402740321.63333370.0166.300000166.300000NaN59.510.36666745.02.107004e+072.552496e+074.072.0286.333333286.3333338428018.010550477.03.792280e+064.534767e+063.536.50000067.99421555.2086294.244919e+065.306148e+062.933333123638.4123638.43.01.02.9333330.33333361819.261819.2ENTIDADES EMPRESARIAISSEGUROS RESSEGUROS PREVIDENCIA COMPLEMENTAR E PLANOS DE SAUDEVALE DO ACRERIO BRANCOATIVIDADES FINANCEIRAS DE SEGUROS E SERVICOS RELACIONADOS23.070.8329.17282.018.0NaNNaNNaNNaN1.06.06.00.00.00.00.00.00.06.00.00.00.01.00.00.00.00.01.06.00.00.00.05.00.00.05.01.00.00.0161.011.0160.05121.0114.0109.059.073.0319.04.02.04.06.01.03.0NaN4.00.0NaNNaNNaNNaNNaN4.0NaN3.0SERVIÇOACAC2.275368e+07120.07.06.14035111.0091749.36170230033828.061489496.08.489837e+061.061230e+07156585.0NaNNaNNaNNaNNaNNaNNaNNaN2.02.01.01.0
264596.233333NaN16.700000NaNDE R$ 300.000.000,01 A R$ 500.000.000,00DE R$ 500.000.000,01 A 1 BILHAO DE REAISBOASOCIEDADE ANONIMA FECHADAALTAINDUSTRIA DIGITALACIMA DE 1 ANOVERDE2008-01-145985.495.223031e+095.451955e+09FalseTrueFalseFalseTrueFalseFalseFalseFalseTrueSIMTrueFalseFalseFalseTrueFalseNaNNaN140.02447.0563.0251f454db948590c50df496ea83f76e2227e24a32c2814dd00b363fd77754e295.07.0643.0949.0749.0444.0200.095.041.017.010 a 1510.794521596.23333372.0106.631111106.631111NaN52.516.70000035.05.150974e+095.372531e+09275.01716.030.333333146.600000171568880.0241816100.03.482021e+083.634637e+0824.0361.60000023.34154118.2843453.669588e+075.131406e+073.433333210000.0210000.01.010.03.433333-0.466667288489.6288489.6ENTIDADES EMPRESARIAISATIVIDADES DE PRESTACAO DE SERVICOS DE INFORMACAONORTE MARANHENSEAGLOMERACAO URBANA DE SAO LUISINFORMACAO E COMUNICACAO23.033.5666.445340.0465.0NaNNaNNaNNaNNaN15.015.01.00.00.00.00.00.015.00.00.08.01.00.00.00.010.00.015.00.00.04.01.00.010.03.02.00.00.02168.0394.02162.063172.03186.03460.01229.01808.03787.07.04.05.028.0NaN4.0NaN5.00.0NaNNaNNaNNaNNaN4.0NaN5.0SERVIÇOMAMA5.223031e+093150.0288.0-0.439422-8.32369912.561773459934850.0560530400.01.834794e+082.565703e+08NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0